Useful System Procedures
Although hundreds of system-stored procedures exist, you will find a core group of 10 or 20 that you commonly use on your system. Many of the procedures prefixed as sp_help are, to risk stating the obvious, helpful. For instance, sp_helpdb returns information about all databases, or if a database name is specified, about a single database, such as sp_helpdb 'pubs'.
Table 10.7 lists some common system-stored procedures.
Procedure Name | Description |
---|---|
sp_help | Lists objects in a database or returns information on a specific object. Can be used to obtain information on any database object. |
sp_helpdb | Lists databases or returns information on a specific database. |
sp_helprotect | Displays ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.