Procedimientos almacenados del motor de base de datos (Transact-SQL)Database Engine Stored Procedures (Transact-SQL)

SE APLICA A: síSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noAlmacenamiento de datos paralelos APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] admite los siguientes procedimientos almacenados del sistema que se utilizan para realizar el mantenimiento general de una instancia de [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].[!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports the following system stored procedures that are used for general maintenance of an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. ||| |-|-| |[sp_add_data_file_recover_suspect_dbsp_add_data_file_recover_suspect_db](../../relational-databases/system-stored-procedures/sp-add-data-file-recover-suspect-db-transact-sql.md)|[sp_helpsp_help](../../relational-databases/system-stored-procedures/sp-help-transact-sql.md)| |[sp_add_log_file_recover_suspect_dbsp_add_log_file_recover_suspect_db](../../relational-databases/system-stored-procedures/sp-add-log-file-recover-suspect-db-transact-sql.md)|[sp_helpconstraintsp_helpconstraint](../../relational-databases/system-stored-procedures/sp-helpconstraint-transact-sql.md)| |[sp_addextendedprocsp_addextendedproc](../../relational-databases/system-stored-procedures/sp-addextendedproc-transact-sql.md)|[sp_helpdbsp_helpdb](../../relational-databases/system-stored-procedures/sp-helpdb-transact-sql.md)| |[sp_addextendedpropertysp_addextendedproperty](../../relational-databases/system-stored-procedures/sp-addextendedproperty-transact-sql.md)|[sp_helpdevicesp_helpdevice](../../relational-databases/system-stored-procedures/sp-helpdevice-transact-sql.md)| |[sp_addmessagesp_addmessage](../../relational-databases/system-stored-procedures/sp-addmessage-transact-sql.md)|[sp_helpextendedprocsp_helpextendedproc](../../relational-databases/system-stored-procedures/sp-helpextendedproc-transact-sql.md)| |[sp_addtypesp_addtype](../../relational-databases/system-stored-procedures/sp-addtype-transact-sql.md)|[sp_helpfilesp_helpfile](../../relational-databases/system-stored-procedures/sp-helpfile-transact-sql.md)| |[sp_addumpdevicesp_addumpdevice](../../relational-databases/system-stored-procedures/sp-addumpdevice-transact-sql.md)|[sp_helpfilegroupsp_helpfilegroup](../../relational-databases/system-stored-procedures/sp-helpfilegroup-transact-sql.md)| |[sp_altermessagesp_altermessage](../../relational-databases/system-stored-procedures/sp-altermessage-transact-sql.md)|[sp_helpindexsp_helpindex](../../relational-databases/system-stored-procedures/sp-helpindex-transact-sql.md)| |[sp_attach_dbsp_attach_db](../../relational-databases/system-stored-procedures/sp-attach-db-transact-sql.md)|[sp_helplanguagesp_helplanguage](../../relational-databases/system-stored-procedures/sp-helplanguage-transact-sql.md)| |[sp_attach_single_file_dbsp_attach_single_file_db](../../relational-databases/system-stored-procedures/sp-attach-single-file-db-transact-sql.md)|[sp_helpserversp_helpserver](../../relational-databases/system-stored-procedures/sp-helpserver-transact-sql.md)| |[sp_autostatssp_autostats](../../relational-databases/system-stored-procedures/sp-autostats-transact-sql.md)|[sp_helpsortsp_helpsort](../../relational-databases/system-stored-procedures/sp-helpsort-transact-sql.md)| |[sp_bindefaultsp_bindefault](../../relational-databases/system-stored-procedures/sp-bindefault-transact-sql.md)|[sp_helpstatssp_helpstats](../../relational-databases/system-stored-procedures/sp-helpstats-transact-sql.md)| |[sp_bindrulesp_bindrule](../../relational-databases/system-stored-procedures/sp-bindrule-transact-sql.md)|[sp_helptextsp_helptext](../../relational-databases/system-stored-procedures/sp-helptext-transact-sql.md)| |[sp_bindsessionsp_bindsession](../../relational-databases/system-stored-procedures/sp-bindsession-transact-sql.md)|[sp_helptriggersp_helptrigger](../../relational-databases/system-stored-procedures/sp-helptrigger-transact-sql.md)| |[sp_certify_removablesp_certify_removable](../../relational-databases/system-stored-procedures/sp-certify-removable-transact-sql.md)|[sp_indexoptionsp_indexoption](../../relational-databases/system-stored-procedures/sp-indexoption-transact-sql.md)| |[sp_clean_db_file_free_spacesp_clean_db_file_free_space](../../relational-databases/system-stored-procedures/sp-clean-db-file-free-space-transact-sql.md)|[sp_invalidate_textptrsp_invalidate_textptr](../../relational-databases/system-stored-procedures/sp-invalidate-textptr-transact-sql.md)| |[sp_clean_db_free_spacesp_clean_db_free_space](../../relational-databases/system-stored-procedures/sp-clean-db-free-space-transact-sql.md)|[sp_locksp_lock](../../relational-databases/system-stored-procedures/sp-lock-transact-sql.md)| |[sp_configuresp_configure](../../relational-databases/system-stored-procedures/sp-configure-transact-sql.md)|[sys.sp_merge_xtp_checkpoint_filessys.sp_merge_xtp_checkpoint_files](../../relational-databases/system-stored-procedures/sys-sp-xtp-merge-checkpoint-files-transact-sql.md)| |[sp_control_plan_guidesp_control_plan_guide](../../relational-databases/system-stored-procedures/sp-control-plan-guide-transact-sql.md)|[sp_monitorsp_monitor](../../relational-databases/system-stored-procedures/sp-monitor-transact-sql.md)| |[sp_create_plan_guidesp_create_plan_guide](../../relational-databases/system-stored-procedures/sp-create-plan-guide-transact-sql.md)|[sp_preparesp_prepare](../../relational-databases/system-stored-procedures/sp-prepare-transact-sql.md)| |[sp_create_plan_guide_from_handlesp_create_plan_guide_from_handle](../../relational-databases/system-stored-procedures/sp-create-plan-guide-from-handle-transact-sql.md)|[sp_prepexecsp_prepexec](../../relational-databases/system-stored-procedures/sp-prepexec-transact-sql.md)| |[sp_create_removablesp_create_removable](../../relational-databases/system-stored-procedures/sp-create-removable-transact-sql.md)|[sp_prepexecrpcsp_prepexecrpc](../../relational-databases/system-stored-procedures/sp-prepexecrpc-transact-sql.md)| |[sp_createstatssp_createstats](../../relational-databases/system-stored-procedures/sp-createstats-transact-sql.md)|[sp_procoptionsp_procoption](../../relational-databases/system-stored-procedures/sp-procoption-transact-sql.md)| |[sp_cycle_errorlogsp_cycle_errorlog](../../relational-databases/system-stored-procedures/sp-cycle-errorlog-transact-sql.md)|[sp_recompilesp_recompile](../../relational-databases/system-stored-procedures/sp-recompile-transact-sql.md)| |[sp_datatype_infosp_datatype_info](../../relational-databases/system-stored-procedures/sp-datatype-info-transact-sql.md)|[sp_refreshviewsp_refreshview](../../relational-databases/system-stored-procedures/sp-refreshview-transact-sql.md)| |[sp_db_increased_partitionssp_db_increased_partitions](../../relational-databases/system-stored-procedures/sp-db-increased-partitions.md)|[sp_releaseapplocksp_releaseapplock](../../relational-databases/system-stored-procedures/sp-releaseapplock-transact-sql.md)| |[sp_dbcmptlevelsp_dbcmptlevel](../../relational-databases/system-stored-procedures/sp-dbcmptlevel-transact-sql.md)|[sp_renamesp_rename](../../relational-databases/system-stored-procedures/sp-rename-transact-sql.md)| |[sp_dbmmonitoraddmonitoringsp_dbmmonitoraddmonitoring](../../relational-databases/system-stored-procedures/sp-dbmmonitoraddmonitoring-transact-sql.md)|[sp_renamedbsp_renamedb](../../relational-databases/system-stored-procedures/sp-renamedb-transact-sql.md)| |[sp_dbmmonitorchangealertsp_dbmmonitorchangealert](../../relational-databases/system-stored-procedures/sp-dbmmonitorchangealert-transact-sql.md)|[sp_resetstatussp_resetstatus](../../relational-databases/system-stored-procedures/sp-resetstatus-transact-sql.md)| |[sp_dbmmonitorchangemonitoringsp_dbmmonitorchangemonitoring](../../relational-databases/system-stored-procedures/sp-dbmmonitorchangemonitoring-transact-sql.md)|[sp_sequence_get_rangesp_sequence_get_range](../../relational-databases/system-stored-procedures/sp-sequence-get-range-transact-sql.md)| |[sp_dbmmonitordropalertsp_dbmmonitordropalert](../../relational-databases/system-stored-procedures/sp-dbmmonitordropalert-transact-sql.md)|[sp_serveroptionsp_serveroption](../../relational-databases/system-stored-procedures/sp-serveroption-transact-sql.md)| |[sp_dbmmonitordropmonitoringsp_dbmmonitordropmonitoring](../../relational-databases/system-stored-procedures/sp-dbmmonitordropmonitoring-transact-sql.md)|[sp_set_session_contextsp_set_session_context](../../relational-databases/system-stored-procedures/sp-set-session-context-transact-sql.md)| |[sp_dbmmonitorhelpalertsp_dbmmonitorhelpalert](../../relational-databases/system-stored-procedures/sp-dbmmonitorhelpalert-transact-sql.md)|[sp_setnetnamesp_setnetname](../../relational-databases/system-stored-procedures/sp-setnetname-transact-sql.md)| |[sp_dbmmonitorhelpmonitoringsp_dbmmonitorhelpmonitoring](../../relational-databases/system-stored-procedures/sp-dbmmonitorhelpmonitoring-transact-sql.md)|[sp_settriggerordersp_settriggerorder](../../relational-databases/system-stored-procedures/sp-settriggerorder-transact-sql.md)| |[sp_dbmmonitorresultssp_dbmmonitorresults](../../relational-databases/system-stored-procedures/sp-dbmmonitorresults-transact-sql.md)|[sp_spaceusedsp_spaceused](../../relational-databases/system-stored-procedures/sp-spaceused-transact-sql.md)| |[sp_delete_backuphistorysp_delete_backuphistory](../../relational-databases/system-stored-procedures/sp-delete-backuphistory-transact-sql.md)|[sp_tableoptionsp_tableoption](../../relational-databases/system-stored-procedures/sp-tableoption-transact-sql.md)| |[sp_dependssp_depends](../../relational-databases/system-stored-procedures/sp-depends-transact-sql.md)|[sp_unbindefaultsp_unbindefault](../../relational-databases/system-stored-procedures/sp-unbindefault-transact-sql.md)| |[sp_describe_first_result_setsp_describe_first_result_set](../../relational-databases/system-stored-procedures/sp-describe-first-result-set-transact-sql.md)|[sp_unbindrulesp_unbindrule](../../relational-databases/system-stored-procedures/sp-unbindrule-transact-sql.md)| |[sp_describe_undeclared_parameterssp_describe_undeclared_parameters](../../relational-databases/system-stored-procedures/sp-describe-undeclared-parameters-transact-sql.md)|[sp_updateextendedpropertysp_updateextendedproperty](../../relational-databases/system-stored-procedures/sp-updateextendedproperty-transact-sql.md)| |[sp_detach_dbsp_detach_db](../../relational-databases/system-stored-procedures/sp-detach-db-transact-sql.md)|[sp_updatestatssp_updatestats](../../relational-databases/system-stored-procedures/sp-updatestats-transact-sql.md)| |[sp_dropdevicesp_dropdevice](../../relational-databases/system-stored-procedures/sp-dropdevice-transact-sql.md)|[sp_unpreparesp_unprepare](../../relational-databases/system-stored-procedures/sp-unprepare-transact-sql.md)| |[sp_dropextendedprocsp_dropextendedproc](../../relational-databases/system-stored-procedures/sp-dropextendedproc-transact-sql.md)|[sp_validnamesp_validname](../../relational-databases/system-stored-procedures/sp-validname-transact-sql.md)| |[sp_dropextendedpropertysp_dropextendedproperty](../../relational-databases/system-stored-procedures/sp-dropextendedproperty-transact-sql.md)|[sp_whosp_who](../../relational-databases/system-stored-procedures/sp-who-transact-sql.md)| |[sp_dropmessagesp_dropmessage](../../relational-databases/system-stored-procedures/sp-dropmessage-transact-sql.md)|[sys.sp_xtp_control_proc_exec_statssys.sp_xtp_control_proc_exec_stats](../../relational-databases/system-stored-procedures/sys-sp-xtp-control-proc-exec-stats-transact-sql.md)| |[sp_droptypesp_droptype](../../relational-databases/system-stored-procedures/sp-droptype-transact-sql.md)|[sys.sp_flush_logsys.sp_flush_log](../../relational-databases/system-stored-procedures/sys-sp-flush-log-transact-sql.md)| |[sp_executesp_execute](../../relational-databases/system-stored-procedures/sp-execute-transact-sql.md)|[sys.sp_xtp_bind_db_resource_poolsys.sp_xtp_bind_db_resource_pool](../../relational-databases/system-stored-procedures/sys-sp-xtp-bind-db-resource-pool-transact-sql.md)| |[sp_executesqlsp_executesql](../../relational-databases/system-stored-procedures/sp-executesql-transact-sql.md)|[sys.sp_xtp_control_query_exec_statssys.sp_xtp_control_query_exec_stats](../../relational-databases/system-stored-procedures/sys-sp-xtp-control-query-exec-stats-transact-sql.md)| |[sp_getapplocksp_getapplock](../../relational-databases/system-stored-procedures/sp-getapplock-transact-sql.md)|[sys.sp_xtp_checkpoint_force_garbage_collectionsys.sp_xtp_checkpoint_force_garbage_collection](../../relational-databases/system-stored-procedures/sys-sp-xtp-checkpoint-force-garbage-collection-transact-sql.md)| |[sp_getbindtokensp_getbindtoken](../../relational-databases/system-stored-procedures/sp-getbindtoken-transact-sql.md)|[sys.sp_xtp_unbind_db_resource_poolsys.sp_xtp_unbind_db_resource_pool](../../relational-databases/system-stored-procedures/sys-sp-xtp-unbind-db-resource-pool-transact-sql.md)| ## Consulte tambiénSee Also [Procedimientos almacenados del sistema (Transact-SQL)System Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/system-stored-procedures-transact-sql.md)