Database Engine Stored Procedures (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

Database Engine Stored Procedures (Transact-SQL)

 

Updated: November 2, 2015

Applies To: Azure SQL Database, SQL Server 2014, SQL Server 2016 Preview

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

Community Additions

ADD
Show:
© 2016 Microsoft