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_Obj | sp_ActiveDirectory_SCP\eop |
| Catalog Procedures | |
|---|---|
| sp_column_privileges | sp_special_columns |
| sp_columns | sp_sproc_columns |
| sp_databases | sp_statistics |
| sp_fkeys | sp_stored_procedures |
| sp_pkeys | sp_table_privileges |
| sp_server_info | sp_tables |
| Cursor Procedures | |
|---|---|
| sp_cursor_list | sp_describe_cursor_columns |
| sp_describe_cursor | sp_describe_cursor_tables |
| Database Maintenance Plan Procedures | |
|---|---|
| sp_add_maintenance_plan ... | |
Get Transact-SQL Desk Reference 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.
