Creating Supplemental Stored Procedures

The following sections contain code for several useful stored procedures that you can add to your master database. Although these procedures can help you diagnose and recover from certain problems, keep in mind that these procedures are not part of the supported feature set. The performance and reliability of these stored procedures might not be at the level of the supported system procedures, and future compatibility or continued use is not assured.

Note The text of these stored procedures can be found in the INSTSUPL.SQL script installed in the \SQL60\INSTALL directory by the setup program.

For additional information about creating and using stored procedures, see the Microsoft SQL Server Transact-SQL Reference.