Database Engine Stored Procedures (Transact-SQL)

May 8, 2015
| No Comments

Database Engine Stored Procedures (Transact-SQL)

SQL Server 2014

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