TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Database Engine Stored Procedures (Transact-SQL)

 

Updated: November 2, 2015

SQL Server supports the following system stored procedures that are used for general maintenance of an instance of SQL Server.

sp_add_data_file_recover_suspect_dbsp_help
sp_add_log_file_recover_suspect_dbsp_helpconstraint
sp_addextendedprocsp_helpdb
sp_addextendedpropertysp_helpdevice
sp_addmessagesp_helpextendedproc
sp_addtypesp_helpfile
sp_addumpdevicesp_helpfilegroup
sp_altermessagesp_helpindex
sp_attach_dbsp_helplanguage
sp_attach_single_file_dbsp_helpserver
sp_autostatssp_helpsort
sp_bindefaultsp_helpstats
sp_bindrulesp_helptext
sp_bindsessionsp_helptrigger
sp_certify_removablesp_indexoption
sp_clean_db_file_free_spacesp_invalidate_textptr
sp_clean_db_free_spacesp_lock
sp_configuresys.sp_merge_xtp_checkpoint_files
sp_control_plan_guidesp_monitor
sp_create_plan_guidesp_prepare
sp_create_plan_guide_from_handlesp_prepexec
sp_create_removablesp_prepexecrpc
sp_createstatssp_procoption
sp_cycle_errorlogsp_recompile
sp_datatype_infosp_refreshview
sp_db_increased_partitionssp_releaseapplock
sp_dbcmptlevelsp_rename
sp_dbmmonitoraddmonitoringsp_renamedb
sp_dbmmonitorchangealertsp_resetstatus
sp_dbmmonitorchangemonitoringsp_sequence_get_range
sp_dbmmonitordropalertsp_serveroption
sp_dbmmonitordropmonitoringsp_set_session_context
sp_dbmmonitorhelpalertsp_setnetname
sp_dbmmonitorhelpmonitoringsp_settriggerorder
sp_dbmmonitorresultssp_spaceused
sp_delete_backuphistorysp_tableoption
sp_dependssp_unbindefault
sp_describe_first_result_setsp_unbindrule
sp_describe_undeclared_parameterssp_updateextendedproperty
sp_detach_dbsp_updatestats
sp_dropdevicesp_unprepare
sp_dropextendedprocsp_validname
sp_dropextendedpropertysp_who
sp_dropmessagesys.sp_xtp_control_proc_exec_stats
sp_droptypesys.sp_flush_log
sp_executesys.sp_xtp_bind_db_resource_pool
sp_executesqlsys.sp_xtp_control_query_exec_stats
sp_getapplocksys.sp_xtp_checkpoint_force_garbage_collection
sp_getbindtokensys.sp_xtp_unbind_db_resource_pool

System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft