The information in this article applies to:
Under SQL Server version 4.2, stored procedures can report a return status that indicates whether they completed successfully or the reasons for failure. SQL Server-defined return status values for failure range from -1 to -99; users can define their own return status values outside this range. Under the 4.2 release, failure values -1 to -14 are currently in use, with 0 indicating a successful completion. These reserved return values actually map to the 10--the severity level of the error causing the execution failure in the stored procedure. For instance, a severity 16 error within the stored procedure causes a status of -6 (10-16) to be returned. Similarly, a severity 24 error would cause a return status of -14. When executing remote procedure calls across SQL Servers, a -6 return status will also be returned in the event that the remote procedure does not exist. Additional query words: 4.20 4.20a Transact-SQL
Keywords : kbprg SSrvTran_SQL |
|
Last Reviewed: March 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |