Category:
System Stored Procedure Library
Sub-Categories:
0,
Documents:
8,
Last Update:
Jun 2, 2008 11:22 AM
This is a quick reference for the usable system procedures in Microsoft SQL Server. Not all system stored procedures are in scope, only the ones considered to be most useful. Focus is on SQL Server 2005 system procedures.
Initial categories utilized are defined using http://msdn2.microsoft.com/en-us/library/ms187961.aspx:
Catalog
Database Engine
Distributed Queries
General Extended
Security
SQL Profiler
SQL Server Agent
Undocumented
All system stored procedures are located inside the master database, except for the SQL Server Agent stored procedures. Those are located in the msdb database, and as a result the user will either need to connect to the msdb database or issue an execute command as follows:
EXEC msdb..[proc_name]
|
|
Documents in Category
|
|
|
|
|
