Click to Rate and Give Feedback

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (4)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
Database Engine Stored Procedures (Transact-SQL)

SQL Server 2008 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_dropmessage

sp_add_log_file_recover_suspect_db

sp_droptype

sp_addextendedproc

sp_executesql

sp_addextendedproperty

sp_getapplock

sp_addmessage

sp_getbindtoken

sp_addtype

sp_help

sp_addumpdevice

sp_helpconstraint

sp_altermessage

sp_helpdb

sp_attach_db

sp_helpdevice

sp_attach_single_file_db

sp_helpextendedproc

sp_autostats

sp_helpfile

sp_bindefault

sp_helpfilegroup

sp_bindrule

sp_helpindex

sp_bindsession

sp_helplanguage

sp_certify_removable

sp_helpserver

sp_clean_db_file_free_space

sp_helpsort

sp_clean_db_free_space

sp_helpstats

sp_configure

sp_helptext

sp_control_plan_guide

sp_helptrigger

sp_create_plan_guide

sp_indexoption

sp_create_plan_guide_from_handle

sp_invalidate_textptr

sp_create_removable

sp_lock

sp_createstats

sp_monitor

sp_cycle_errorlog

sp_procoption

sp_datatype_info

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_serveroption

sp_dbmmonitorhelpalert

sp_setnetname

sp_dbmmonitorhelpmonitoring

sp_settriggerorder

sp_dbmmonitorresults

sp_spaceused

sp_dboption

sp_tableoption

sp_dbremove

sp_unbindefault

sp_delete_backuphistory

sp_unbindrule

sp_depends

sp_updateextendedproperty

sp_detach_db

sp_updatestats

sp_dropdevice

sp_validname

sp_dropextendedproc

sp_who

sp_dropextendedproperty

 

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker