Хранимые процедуры ядра СУБД (Transact-SQL)Database Engine Stored Procedures (Transact-SQL)

  • Время чтения: 2 мин

ОБЛАСТЬ ПРИМЕНЕНИЯ: даSQL Server нетБаза данных SQL Azure нетAzure Synapse Analytics (хранилище данных SQL) нетParallel Data Warehouse APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

SQL ServerSQL Server поддерживает следующие системные хранимые процедуры, используемые для общего обслуживания экземпляра SQL ServerSQL Server.supports the following system stored procedures that are used for general maintenance of an instance of SQL ServerSQL Server.
sp_add_data_file_recover_suspect_dbsp_add_data_file_recover_suspect_db sp_helpsp_help
sp_add_log_file_recover_suspect_dbsp_add_log_file_recover_suspect_db sp_helpconstraintsp_helpconstraint
sp_addextendedprocsp_addextendedproc sp_helpdbsp_helpdb
sp_addextendedpropertysp_addextendedproperty sp_helpdevicesp_helpdevice
sp_addmessagesp_addmessage sp_helpextendedprocsp_helpextendedproc
sp_addtypesp_addtype sp_helpfilesp_helpfile
sp_addumpdevicesp_addumpdevice sp_helpfilegroupsp_helpfilegroup
sp_altermessagesp_altermessage sp_helpindexsp_helpindex
sp_attach_dbsp_attach_db sp_helplanguagesp_helplanguage
sp_attach_single_file_dbsp_attach_single_file_db sp_helpserversp_helpserver
sp_autostatssp_autostats sp_helpsortsp_helpsort
sp_bindefaultsp_bindefault sp_helpstatssp_helpstats
sp_bindrulesp_bindrule sp_helptextsp_helptext
sp_bindsessionsp_bindsession sp_helptriggersp_helptrigger
sp_certify_removablesp_certify_removable sp_indexoptionsp_indexoption
sp_clean_db_file_free_spacesp_clean_db_file_free_space sp_invalidate_textptrsp_invalidate_textptr
sp_clean_db_free_spacesp_clean_db_free_space sp_locksp_lock
sp_configuresp_configure sys.sp_merge_xtp_checkpoint_filessys.sp_merge_xtp_checkpoint_files
sp_control_plan_guidesp_control_plan_guide sp_monitorsp_monitor
sp_create_plan_guidesp_create_plan_guide sp_preparesp_prepare
sp_create_plan_guide_from_handlesp_create_plan_guide_from_handle sp_prepexecsp_prepexec
sp_create_removablesp_create_removable sp_prepexecrpcsp_prepexecrpc
sp_createstatssp_createstats sp_procoptionsp_procoption
sp_cycle_errorlogsp_cycle_errorlog sp_recompilesp_recompile
sp_datatype_infosp_datatype_info sp_refreshviewsp_refreshview
sp_db_increased_partitionssp_db_increased_partitions sp_releaseapplocksp_releaseapplock
sp_dbcmptlevelsp_dbcmptlevel sp_renamesp_rename
sp_dbmmonitoraddmonitoringsp_dbmmonitoraddmonitoring sp_renamedbsp_renamedb
sp_dbmmonitorchangealertsp_dbmmonitorchangealert sp_resetstatussp_resetstatus
sp_dbmmonitorchangemonitoringsp_dbmmonitorchangemonitoring sp_sequence_get_rangesp_sequence_get_range
sp_dbmmonitordropalertsp_dbmmonitordropalert sp_serveroptionsp_serveroption
sp_dbmmonitordropmonitoringsp_dbmmonitordropmonitoring sp_set_session_contextsp_set_session_context
sp_dbmmonitorhelpalertsp_dbmmonitorhelpalert sp_setnetnamesp_setnetname
sp_dbmmonitorhelpmonitoringsp_dbmmonitorhelpmonitoring sp_settriggerordersp_settriggerorder
sp_dbmmonitorresultssp_dbmmonitorresults sp_spaceusedsp_spaceused
sp_delete_backuphistorysp_delete_backuphistory sp_tableoptionsp_tableoption
sp_dependssp_depends sp_unbindefaultsp_unbindefault
sp_describe_first_result_setsp_describe_first_result_set sp_unbindrulesp_unbindrule
sp_describe_undeclared_parameterssp_describe_undeclared_parameters sp_updateextendedpropertysp_updateextendedproperty
sp_detach_dbsp_detach_db sp_updatestatssp_updatestats
sp_dropdevicesp_dropdevice sp_unpreparesp_unprepare
sp_dropextendedprocsp_dropextendedproc sp_validnamesp_validname
sp_dropextendedpropertysp_dropextendedproperty sp_whosp_who
sp_dropmessagesp_dropmessage sys.sp_xtp_control_proc_exec_statssys.sp_xtp_control_proc_exec_stats
sp_droptypesp_droptype sys.sp_flush_logsys.sp_flush_log
sp_executesp_execute sys.sp_xtp_bind_db_resource_poolsys.sp_xtp_bind_db_resource_pool
sp_executesqlsp_executesql sys.sp_xtp_control_query_exec_statssys.sp_xtp_control_query_exec_stats
sp_getapplocksp_getapplock sys.sp_xtp_checkpoint_force_garbage_collectionsys.sp_xtp_checkpoint_force_garbage_collection
sp_getbindtokensp_getbindtoken sys.sp_xtp_unbind_db_resource_poolsys.sp_xtp_unbind_db_resource_pool

См. такжеSee Also

Системные хранимые процедуры (Transact-SQL)System Stored Procedures (Transact-SQL)