Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Database Engine
Transact-SQL Reference (Database Engine)
System Stored Procedures (Transact-SQL)
Database Engine Stored Procedures (Transact-SQL)
sp_add_data_file_recover_suspect_db (Transact-SQL)
sp_addextendedproc (Transact-SQL)
sp_addextendedproperty (Transact-SQL)
sp_add_log_file_recover_suspect_db (Transact-SQL)
sp_addmessage (Transact-SQL)
sp_addtype (Transact-SQL)
sp_addumpdevice (Transact-SQL)
sp_altermessage (Transact-SQL)
sp_attach_db (Transact-SQL)
sp_attach_single_file_db (Transact-SQL)
sp_autostats (Transact-SQL)
sp_batch_params (Transact-SQL)
sp_bindefault (Transact-SQL)
sp_bindrule (Transact-SQL)
sp_bindsession (Transact-SQL)
sp_certify_removable (Transact-SQL)
sp_clean_db_free_space (Transact-SQL)
sp_clean_db_file_free_space (Transact-SQL)
sp_configure (Transact-SQL)
sp_control_plan_guide (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)
sp_create_removable (Transact-SQL)
sp_createstats (Transact-SQL)
sp_datatype_info (Transact-SQL)
sp_db_increased_partitions
sp_db_vardecimal_storage_format (Transact-SQL)
sp_dbcmptlevel (Transact-SQL)
sp_dbmmonitoraddmonitoring (Transact-SQL)
sp_dbmmonitorchangealert (Transact-SQL)
sp_dbmmonitorchangemonitoring (Transact-SQL)
sp_dbmmonitordropalert (Transact-SQL)
sp_dbmmonitordropmonitoring (Transact-SQL)
sp_dbmmonitorhelpalert (Transact-SQL)
sp_dbmmonitorhelpmonitoring (Transact-SQL)
sp_dbmmonitorresults (Transact-SQL)
sp_dbmmonitorupdate (Transact-SQL)
sp_dbremove (Transact-SQL)
sp_delete_backuphistory (Transact-SQL)
sp_delete_database_backuphistory (Transact-SQL)
sp_depends (Transact-SQL)
sp_describe_first_result_set (Transact-SQL)
sp_describe_undeclared_parameters (Transact-SQL)
sp_detach_db (Transact-SQL)
sp_dropdevice (Transact-SQL)
sp_dropextendedproc (Transact-SQL)
sp_dropextendedproperty (Transact-SQL)
sp_dropmessage (Transact-SQL)
sp_droptype (Transact-SQL)
sp_estimate_data_compression_savings (Transact-SQL)
sp_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)
sp_executesql (Transact-SQL)
sp_getbindtoken (Transact-SQL)
sp_getapplock (Transact-SQL)
sp_get_query_template (Transact-SQL)
sp_help (Transact-SQL)
sp_helpconstraint (Transact-SQL)
sp_helpdb (Transact-SQL)
sp_helpdevice (Transact-SQL)
sp_helpextendedproc (Transact-SQL)
sp_helpfile (Transact-SQL)
sp_helpfilegroup (Transact-SQL)
sp_helpindex (Transact-SQL)
sp_helplanguage (Transact-SQL)
sp_helpserver (Transact-SQL)
sp_helpsort (Transact-SQL)
sp_helpstats (Transact-SQL)
sp_helptext (Transact-SQL)
sp_helptrigger (Transact-SQL)
sp_indexoption (Transact-SQL)
sp_invalidate_textptr (Transact-SQL)
sp_lock (Transact-SQL)
sp_monitor (Transact-SQL)
sp_procoption (Transact-SQL)
sp_recompile (Transact-SQL)
sp_refreshsqlmodule (Transact-SQL)
sp_refreshview (Transact-SQL)
sp_releaseapplock (Transact-SQL)
sp_rename (Transact-SQL)
sp_renamedb (Transact-SQL)
sp_resetstatus (Transact-SQL)
sp_sequence_get_range (Transact-SQL)
sp_server_diagnostics (Transact-SQL)
sp_setnetname (Transact-SQL)
sp_settriggerorder (Transact-SQL)
sp_spaceused (Transact-SQL)
sp_tableoption (Transact-SQL)
sp_unbindefault (Transact-SQL)
sp_unbindrule (Transact-SQL)
sp_updateextendedproperty (Transact-SQL)
sp_updatestats (Transact-SQL)
sp_validname (Transact-SQL)
sp_who (Transact-SQL)
Expand Minimize
4 out of 5 rated this helpful - Rate this topic

Database Engine Stored Procedures (Transact-SQL)

SQL Server 2012

SQL Server 2012 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_execute

sp_add_log_file_recover_suspect_db

sp_executesql

sp_addextendedproc

sp_getapplock

sp_addextendedproperty

sp_getbindtoken

sp_addmessage

sp_help

sp_addtype

sp_helpconstraint

sp_addumpdevice

sp_helpdb

sp_altermessage

sp_helpdevice

sp_attach_db

sp_helpextendedproc

sp_attach_single_file_db

sp_helpfile

sp_autostats

sp_helpfilegroup

sp_bindefault

sp_helpindex

sp_bindrule

sp_helplanguage

sp_bindsession

sp_helpserver

sp_certify_removable

sp_helpsort

sp_clean_db_file_free_space

sp_helpstats

sp_clean_db_free_space

sp_helptext

sp_configure

sp_helptrigger

sp_control_plan_guide

sp_indexoption

sp_create_plan_guide

sp_invalidate_textptr

sp_create_plan_guide_from_handle

sp_lock

sp_create_removable

sp_monitor

sp_createstats

sp_prepare

sp_cycle_errorlog

sp_prepexec

sp_datatype_info

sp_prepexecrpc

sp_db_increased_partitions

sp_procoption

sp_dbcmptlevel

sp_recompile

sp_dbmmonitoraddmonitoring

sp_refreshview

sp_dbmmonitorchangealert

sp_releaseapplock

sp_dbmmonitorchangemonitoring

sp_rename

sp_dbmmonitordropalert

sp_renamedb

sp_dbmmonitordropmonitoring

sp_resetstatus

sp_dbmmonitorhelpalert

sp_sequence_get_range (Transact-SQL)

sp_dbmmonitorhelpmonitoring

sp_serveroption

sp_dbmmonitorresults

sp_setnetname

sp_delete_backuphistory

sp_settriggerorder

sp_depends

sp_spaceused

sp_describe_first_result_set (Transact-SQL)

sp_tableoption

sp_describe_undeclared_parameters (Transact-SQL)

sp_unbindefault

sp_detach_db

sp_unbindrule

sp_dropdevice

sp_updateextendedproperty

sp_dropextendedproc

sp_updatestats

sp_dropextendedproperty

sp_unprepare

sp_dropmessage

sp_validname

sp_droptype

sp_who

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.