[dba-SQLServer]Error Handler (was Sproc not returning records)

David Emerson davide at dalyn.co.nz
Tue Jan 20 16:05:57 CST 2004


This was a handler I was given by someone else.  What is wrong with it and 
how should it be fixed?

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Churton Park
Wellington, New Zealand
Ph/Fax (877) 456-1205

At 20/01/2004, Robert Djabarov  wrote:
>The error handling specified will not work correctly if the actual error
>occurs.
>
>/*
>If @@Error <> 0
>      Begin
>           Select 'Unexpected error occurred: ', @@Error
>           Return @@Error
>      End
>else
>     return 0
>*/



More information about the dba-SQLServer mailing list