Get an error code after calling a SQL Server Stored Procedure.

[ab]

In my ASP page I'm calling a Stored Procedure on my SQL Server. No
problem. But I want to check if my SP returned an error (and what kind
of error) instead of the required result.
To call the SP I'm using the code on
http://support.microsoft.com/kb/q164485

All hints are appreciated.

 

[Guest]

Are you refering errors that are raised using 'Raiserror'?

can't the error be caught using 'Try Catch' block?