A.2. SYSTEM STORED PROCEDURES

The following is a list of system stored procedures by category. For details look up the stored procedure by name in Books Online.

Unless specifically documented otherwise, all system stored procedures return a value of zero, which indicates success. To indicate failure, a nonzero value is returned.

Active Directory Procedures
sp_ActiveDirectory_Objsp_ActiveDirectory_SCP\eop
Catalog Procedures
sp_column_privilegessp_special_columns
sp_columnssp_sproc_columns
sp_databasessp_statistics
sp_fkeyssp_stored_procedures
sp_pkeyssp_table_privileges
sp_server_infosp_tables
Cursor Procedures
sp_cursor_listsp_describe_cursor_columns
sp_describe_cursorsp_describe_cursor_tables
Database Maintenance Plan Procedures
sp_add_maintenance_plan ...

Get Transact-SQL Desk Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.