Stored procedures report a return status that indicates whether or not they completed successfully, and if they did not, the reasons for failure. For more information about the return values for system procedures, see “Return values” in Chapter 16, “Using Stored Procedures,” in the Transact-SQL User’s Guide.
