INF: Checking Results of Stored Procedures with RAISERROR

ID: Q67933

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

One way to check the results of a stored procedure is to use RAISERROR within the stored procedure to set the global variable @@ERROR. Then, when you return to the first procedure, you can check for the value of @@ERROR.

Another way to check the results of a stored procedure is to determine the number of open transactions by referencing the global variable @@TRANCOUNT.


Keywords          : kbprg SSrvStProc 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 10, 1999