Database Engine Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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_db sp_help
sp_add_log_file_recover_suspect_db sp_helpconstraint
sp_addextendedproc sp_helpdb
sp_addextendedproperty sp_helpdevice
sp_addmessage sp_helpextendedproc
sp_addtype sp_helpfile
sp_addumpdevice sp_helpfilegroup
sp_altermessage sp_helpindex
sp_attach_db sp_helplanguage
sp_attach_single_file_db sp_helpserver
sp_autostats sp_helpsort
sp_bindefault sp_helpstats
sp_bindrule sp_helptext
sp_bindsession sp_helptrigger
sp_certify_removable sp_indexoption
sp_clean_db_file_free_space sp_invalidate_textptr
sp_clean_db_free_space sp_lock
sp_configure sys.sp_merge_xtp_checkpoint_files
sp_control_plan_guide sp_monitor
sp_create_plan_guide sp_prepare
sp_create_plan_guide_from_handle sp_prepexec
sp_create_removable sp_prepexecrpc
sp_createstats sp_procoption
sp_cycle_errorlog sp_recompile
sp_datatype_info sp_refreshview
sp_db_increased_partitions sp_releaseapplock
sp_dbcmptlevel sp_rename
sp_dbmmonitoraddmonitoring sp_renamedb
sp_dbmmonitorchangealert sp_resetstatus
sp_dbmmonitorchangemonitoring sp_sequence_get_range
sp_dbmmonitordropalert sp_serveroption
sp_dbmmonitordropmonitoring sp_set_session_context
sp_dbmmonitorhelpalert sp_setnetname
sp_dbmmonitorhelpmonitoring sp_settriggerorder
sp_dbmmonitorresults sp_spaceused
sp_delete_backuphistory sp_tableoption
sp_depends sp_unbindefault
sp_describe_first_result_set sp_unbindrule
sp_describe_undeclared_parameters sp_updateextendedproperty
sp_detach_db sp_updatestats
sp_dropdevice sp_unprepare
sp_dropextendedproc sp_validname
sp_dropextendedproperty sp_who
sp_dropmessage sys.sp_xtp_control_proc_exec_stats
sp_droptype sys.sp_flush_log
sp_execute sys.sp_xtp_bind_db_resource_pool
sp_executesql sys.sp_xtp_control_query_exec_stats
sp_getapplock sys.sp_xtp_checkpoint_force_garbage_collection
sp_getbindtoken sys.sp_xtp_unbind_db_resource_pool

See Also

System Stored Procedures (Transact-SQL)