database-engine-stored-procedures-transact-sql.md

title	Database Engine Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	11/02/2015
ms.prod	sql
ms.prod_service	database-engine
ms.component	system-stored-procedures
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	Database Engine [SQL Server], stored procedures system stored procedures [SQL Server], Database Engine stored procedures [SQL Server], Database Engine
ms.assetid	2ce018e9-1a3b-4530-a87d-842456a555ad
caps.latest.revision	42
author	edmacauley
ms.author	edmaca
manager	craigg

Database Engine Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

[!INCLUDEssNoVersion] supports the following system stored procedures that are used for general maintenance of an instance of [!INCLUDEssNoVersion].

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)