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