Defining Utility Stored Procedures
Utility stored procedures give you the ability to maintain your system easily. These stored procedures can be extensions of the Microsoft system stored procedures or can be new ones that, in general, make your life as the administrator easy. When creating utility stored procedures, you interact directly with the system tables in the database by selecting information from them. For the most part, you should never directly change any of the system tables. Microsoft does not recommend, and neither do I, that you directly change any of the data in the system tables. Doing so can damage your SQL Server beyond repair.
Utility stored procedures are procedures that are not tied directly to an application. These stored ...
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
