United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

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_configure (Transact-SQL)

sp_control_plan_guide (Transact-SQL)

sp_create_plan_guide (Transact-SQL)

sp_create_removable (Transact-SQL)

sp_createstats (Transact-SQL)

sp_datatype_info (Transact-SQL)

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_dboption (Transact-SQL)

sp_dbremove (Transact-SQL)

sp_delete_backuphistory (Transact-SQL)

sp_delete_database_backuphistory (Transact-SQL)

sp_depends (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_estimated_rowsize_reduction_for_vardecimal (Transact-SQL)

sp_executesql (Transact-SQL)

sp_get_query_template

sp_getapplock (Transact-SQL)

sp_getbindtoken (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_helpgroup (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_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)

Minimize

6 out of 21 rated this helpful - Rate this topic

Database Engine Stored Procedures (Transact-SQL)

SQL Server 2005

SQL Server 2005 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_estimated_rowsize_reduction_for_vardecimal
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_configure	sp_helpstats
sp_control_plan_guide	sp_helptext
sp_create_plan_guide	sp_helptrigger
sp_create_removable	sp_indexoption
sp_createstats	sp_invalidate_textptr
sp_cycle_errorlog	sp_lock
sp_datatype_info	sp_monitor
sp_db_vardecimal_storage_format	sp_procoption
sp_dbcmptlevel	sp_recompile
sp_dbmmonitoraddmonitoring	sp_refreshsqlmodule
sp_dbmmonitorchangealert	sp_refreshview
sp_dbmmonitorchangemonitoring	sp_releaseapplock
sp_dbmmonitordropalert	sp_rename
sp_dbmmonitordropmonitoring	sp_renamedb
sp_dbmmonitorhelpalert	sp_resetstatus
sp_dbmmonitorhelpmonitoring	sp_serveroption
sp_dbmmonitorresults	sp_setnetname
sp_dboption	sp_settriggerorder
sp_dbremove	sp_spaceused
sp_delete_backuphistory	sp_tableoption
sp_depends	sp_unbindefault
sp_detach_db	sp_unbindrule
sp_dropdevice	sp_updateextendedproperty
sp_dropextendedproc	sp_updatestats
sp_dropextendedproperty	sp_validname
sp_dropmessage	sp_who
sp_droptype

Reference

System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.