SQL Server System stored procedures

System stored Procedures

Active Directory Process

sp_ActiveDirectory_Obj SP_ACTIVEDIRECTORY_SCP

Catalog procedure

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 procedure

Sp_cursor_list sp_describe_cursor_columns

Sp_describe_cursor sp_describe_cursor_tables

Database Maintenance Planning Process

Sp_add_maintenance_plan sp_delete_maintenance_plan_db

sp_add_maintenance_plan_db Sp_delete_maintenance_plan_job

Sp_add_maintenance_plan_job Sp_help_maintenance_plan

Sp_delete_maintenance_plan

Distributed query process

sp_addlinkedserver sp_indexes

sp_addlinkedsrvlogin sp_linkedservers

Sp_catalogs Sp_primarykeys

SP_COLUMN_PRIVILEGES_EX sp_serveroption

SP_COLUMNS_EX SP_TABLE_PRIVILEGES_EX

Sp_droplinkedsrvlogin SP_TABLES_EX

Sp_foreignkeys

Full-Text Search process

Sp_fulltext_catalog sp_help_fulltext_catalogs_cursor

Sp_fulltext_column sp_help_fulltext_columns

Sp_fulltext_database Sp_help_fulltext_columns_cursor

Sp_fulltext_service sp_help_fulltext_tables

Sp_fulltext_table sp_help_fulltext_tables_cursor

Sp_help_fulltext_catalogs

Log shipping Process

Sp_add_log_shipping_database Sp_delete_log_shipping_database

Sp_add_log_shipping_plan Sp_delete_log_shipping_plan

Sp_add_log_shipping_plan_database Sp_delete_log_shipping_plan_database

Sp_add_log_shipping_primary sp_delete_log_shipping_primary

Sp_add_log_shipping_secondary sp_delete_log_shipping_secondary

Sp_can_tlog_be_applied Sp_get_log_shipping_monitor_info

Sp_change_monitor_role Sp_remove_log_shipping_monitor

Sp_change_primary_role sp_resolve_logins

Sp_change_secondary_role Sp_update_log_shipping_monitor_info

Sp_create_log_shipping_monitor_account Sp_update_log_shipping_plan

Sp_define_log_shipping_monitor Sp_update_log_shipping_plan_database

OLE Automation Extended stored procedures

sp_OACreate sp_OAMethod

sp_OADestroy sp_OASetProperty

sp_OAGetErrorInfo sp_OAStop

sp_OAGetProperty Object Hierarchy Syntax

Replication process

Sp_add_agent_parameter sp_enableagentoffload

Sp_add_agent_profile sp_enumcustomresolvers

sp_addarticle SP_ENUMDSN

Sp_adddistpublisher sp_enumfullsubscribers

Sp_adddistributiondb Sp_expired_subscription_cleanup

Sp_adddistributor sp_generatefilters

Sp_addmergealternatepublisher Sp_getagentoffloadinfo

sp_addmergearticle Sp_getmergedeletetype

Sp_addmergefilter Sp_get_distributor

sp_addmergepublication sp_getqueuedrows

Sp_addmergepullsubscription Sp_getsubscriptiondtspackagename

Sp_addmergepullsubscription_agent sp_grant_publication_access

Sp_addmergesubscription Sp_help_agent_default

Sp_addpublication Sp_help_agent_parameter

Sp_addpublication_snapshot Sp_help_agent_profile

Sp_addpublisher70 sp_helparticle

Sp_addpullsubscription sp_helparticlecolumns

Sp_addpullsubscription_agent Sp_helparticledts

Sp_addscriptexec Sp_helpdistpublisher

Sp_addsubscriber sp_helpdistributiondb

Sp_addsubscriber_schedule sp_helpdistributor

sp_addsubscription Sp_helpmergealternatepublisher

Sp_addsynctriggers sp_helpmergearticle

Sp_addtabletocontents Sp_helpmergearticlecolumn

Sp_adjustpublisheridentityrange sp_helpmergearticleconflicts

Sp_article_validation sp_helpmergeconflictrows

Sp_articlecolumn sp_helpmergedeleteconflictrows

Sp_articlefilter Sp_helpmergefilter

Sp_articlesynctranprocs sp_helpmergepublication

Sp_articleview sp_helpmergepullsubscription

Sp_attachsubscription sp_helpmergesubscription

Sp_browsesnapshotfolder sp_helppublication

Sp_browsemergesnapshotfolder sp_help_publication_access

Sp_browsereplcmds sp_helppullsubscription

Sp_change_agent_parameter Sp_helpreplfailovermode

Sp_change_agent_profile sp_helpreplicationdboption

Sp_changearticle sp_helpreplicationoption

Sp_changedistpublisher Sp_helpsubscriberinfo

Sp_changedistributiondb sp_helpsubscription

Sp_changedistributor_password Sp_ivindexhasnullcols

Sp_changedistributor_property sp_helpsubscription_properties

Sp_changemergearticle sp_link_publication

Sp_changemergefilter sp_marksubscriptionvalidation

Sp_changemergepublication Sp_mergearticlecolumn

Sp_changemergepullsubscription sp_mergecleanupmetadata

Sp_changemergesubscription sp_mergedummyupdate

Sp_changepublication sp_mergesubscription_cleanup

Sp_changesubscriber sp_publication_validation

Sp_changesubscriber_schedule sp_refreshsubscriptions

Sp_changesubscriptiondtsinfo sp_reinitmergepullsubscription

Sp_changesubstatus sp_reinitmergesubscription

Sp_change_subscription_properties sp_reinitpullsubscription

Sp_check_for_sync_trigger sp_reinitsubscription

Sp_copymergesnapshot sp_removedbreplication

Sp_copysnapshot sp_repladdcolumn

Sp_copysubscription sp_replcmds

Sp_deletemergeconflictrow sp_replcounters

Sp_disableagentoffload sp_repldone

Sp_drop_agent_parameter sp_repldropcolumn

Sp_drop_agent_profile Sp_replflush

Sp_droparticle sp_replicationdboption

Sp_dropanonymouseagent sp_replication_agent_checkup

Sp_dropdistpublisher Sp_replqueuemonitor

Sp_dropdistributiondb Sp_replsetoriginator

Sp_dropmergealternatepublisher Sp_replshowcmds

Sp_dropdistributor Sp_repltrans

Sp_dropmergearticle sp_restoredbreplication

Sp_dropmergefilter sp_revoke_publication_access

Sp_scriptsubconflicttable

Sp_dropmergepublication sp_script_synctran_commands

Sp_dropmergepullsubscription Sp_setreplfailovermode

Sp_showrowreplicainfo

Sp_dropmergesubscription Sp_subscription_cleanup

Sp_droppublication sp_table_validation

Sp_droppullsubscription Sp_update_agent_profile

Sp_dropsubscriber sp_validatemergepublication

Sp_dropsubscription sp_validatemergesubscription

Sp_dsninfo sp_vupgrade_replication

Sp_dumpparamcmd

Security process

Sp_addalias Sp_droprolemember

Sp_addapprole sp_dropserver

Sp_addgroup sp_dropsrvrolemember

sp_addlinkedsrvlogin sp_dropuser

sp_addlogin sp_grantdbaccess

Sp_addremotelogin sp_grantlogin

Sp_addrole Sp_helpdbfixedrole

sp_addrolemember Sp_helpgroup

sp_addserver Sp_helplinkedsrvlogin

Sp_addsrvrolemember sp_helplogins

Sp_adduser Sp_helpntgroup

Sp_approlepassword Sp_helpremotelogin

Sp_changedbowner Sp_helprole

Sp_changegroup Sp_helprolemember

Sp_changeobjectowner sp_helprotect

Sp_change_users_login Sp_helpsrvrole

Sp_dbfixedrolepermission Sp_helpsrvrolemember

Sp_defaultdb Sp_helpuser

Sp_defaultlanguage sp_mshasdbaccess

Sp_denylogin sp_password

Sp_dropalias sp_remoteoption

Sp_dropapprole sp_revokedbaccess

Sp_dropgroup sp_revokelogin

Sp_droplinkedsrvlogin sp_setapprole

Sp_droplogin sp_srvrolepermission

Sp_dropremotelogin Sp_validatelogins

Sp_droprole

SQL Mail Procedures

Sp_processmail xp_sendmail

Xp_deletemail xp_startmail

xp_findnextmsg Xp_stopmail

xp_readmail

SQL Profiler Procedure

Sp_trace_create sp_trace_setfilter

Sp_trace_generateevent sp_trace_setstatus

Sp_trace_setevent

SQL Server Agent Procedures

Sp_add_alert sp_help_jobhistory

Sp_add_category Sp_help_jobschedule

Sp_add_job Sp_help_jobserver

Sp_add_jobschedule sp_help_jobstep

Sp_add_jobserver sp_help_notification

Sp_add_jobstep Sp_help_operator

Sp_add_notification Sp_help_targetserver

Sp_add_operator Sp_help_targetservergroup

Sp_add_targetservergroup Sp_helptask

Sp_add_targetsvrgrp_member Sp_manage_jobs_by_login

Sp_addtask Sp_msx_defect

Sp_apply_job_to_targets sp_msx_enlist

Sp_delete_alert sp_post_msx_operation

Sp_delete_category sp_purgehistory

Sp_delete_job sp_purge_jobhistory

Sp_delete_jobschedule Sp_reassigntask

Sp_delete_jobserver sp_remove_job_from_targets

Sp_delete_jobstep Sp_resync_targetserver

Sp_delete_notification sp_start_job

Sp_delete_operator sp_stop_job

Sp_delete_targetserver Sp_update_alert

Sp_delete_targetservergroup sp_update_category

Sp_delete_targetsvrgrp_member sp_update_job

Sp_droptask Sp_update_jobschedule

Sp_help_alert Sp_update_jobstep

Sp_help_category sp_update_notification

Sp_help_downloadlist Sp_update_operator

Sp_helphistory Sp_update_targetservergroup

Sp_help_job Sp_updatetask

Xp_sqlagent_proxy_account

System process

sp_add_data_file_recover_suspect_db Sp_helpconstraint

Sp_addextendedproc sp_helpdb

Sp_addextendedproperty sp_helpdevice

sp_add_log_file_recover_suspect_db Sp_helpextendedproc

sp_addmessage sp_helpfile

Sp_addtype Sp_helpfilegroup

Sp_addumpdevice Sp_helpindex

Sp_altermessage sp_helplanguage

Sp_autostats sp_helpserver

sp_attach_db sp_helpsort

sp_attach_single_file_db sp_helpstats

Sp_bindefault sp_helptext

Sp_bindrule sp_helptrigger

Sp_bindsession sp_indexoption

sp_certify_removable sp_invalidate_textptr

sp_configure sp_lock

sp_create_removable sp_monitor

Sp_createstats sp_procoption

Sp_cycle_errorlog sp_recompile

Sp_datatype_info Sp_refreshview

sp_dbcmptlevel Sp_releaseapplock

sp_dboption sp_rename

Sp_dbremove Sp_renamedb

Sp_delete_backuphistory sp_resetstatus

Sp_depends sp_serveroption

sp_detach_db Sp_setnetname

Sp_dropdevice sp_settriggerorder

Sp_dropextendedproc sp_spaceused

Sp_dropextendedproperty sp_tableoption

Sp_dropmessage Sp_unbindefault

Sp_droptype Sp_unbindrule

sp_executesql Sp_updateextendedproperty

Sp_getapplock sp_updatestats

Sp_getbindtoken Sp_validname

Sp_help sp_who

WEB Assistant Process

Sp_dropwebtask sp_makewebtask

Sp_enumcodepages sp_runwebtask

XML process

sp_xml_preparedocument sp_xml_removedocument

General extension Process

xp_cmdshell xp_logininfo

Xp_enumgroups xp_msver

xp_findnextmsg Xp_revokelogin

Xp_grantlogin xp_sprintf

Xp_logevent xp_sqlmaint

Xp_loginconfig

API System Stored Procedures

When users run SQL Server Profiler on ADO, OLE DB, ODBC, and db-library applications, you may notice that the use of system stored procedures does not involve a Transact-SQL Reference. These stored procedures are used by the Microsoft OLE DB provider for SQL Server, the SQL Server ODBC driver, and the db-library dynamic-link library (DLL) to perform database API functions. These procedures are simply mechanisms used by the provider or driver to communicate user requests for SQL Server. They are intended for internal use only for SQL Server OLE DB providers, SQL Server ODBC drivers, and Db-library DLLs. Explicitly calling them from SQL Server applications is not supported.

These stored procedures are supported by API functions that make all of their functionality available to SQL Sever applications. For example, the cursor functionality of a sp_cursor system stored procedure can be used by an OLE DB application through the OLE DB API cursor properties and methods, and ODBE cursor attributes and functions can be used by ODBE applications through the Db-library cursor Library by db-library Application to use.

These system stored procedures support the cursor capabilities of ADO, OLE DB, ODBC, and db-library cursor Library:

Sp_cursor Sp_cursorclose Sp_cursorexecute

Sp_cursorfetch sp_cursoropen sp_cursoroption

Sp_cursorprepare Sp_cursorunprepare

These system stored procedures support the Compare/execute model used to execute Transact-SQL statements in ADO, OLE DB, and ODBC:

Sp_execute Sp_prepare Sp_unprepare

Sp_createorphan and Sp_droporphans stored procedures are used for the processing of ODBC ntext, text, and image.

The sp_reset_connection stored procedure is used by SQL Server to support remote stored procedure calls in a transaction.

The sp_sdidebug stored procedure is used by SQL Server to debug Transact-SQL statements.

SQL Server System stored procedures