Skip to content

Latest commit

 

History

History
235 lines (130 loc) · 7.56 KB

database-engine-stored-procedures-transact-sql.md

File metadata and controls

235 lines (130 loc) · 7.56 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
Database Engine stored procedures (Transact-SQL)
Database Engine stored procedures (Transact-SQL)
markingmyname
maghan
randolphwest
05/24/2023
sql
system-objects
reference
Database Engine [SQL Server], stored procedures
system stored procedures [SQL Server], Database Engine
stored procedures [SQL Server], Database Engine
TSQL

Database Engine stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] supports the following system stored procedures that are used for general maintenance of an instance of [!INCLUDE ssNoVersion].

:::row::: :::column::: sp_add_data_file_recover_suspect_db

    [sp_add_log_file_recover_suspect_db](sp-add-log-file-recover-suspect-db-transact-sql.md)

    [sp_addextendedproc](sp-addextendedproc-transact-sql.md)

    [sp_addextendedproperty](sp-addextendedproperty-transact-sql.md)

    [sp_addmessage](sp-addmessage-transact-sql.md)

    [sp_addtype](sp-addtype-transact-sql.md)

    [sp_addumpdevice](sp-addumpdevice-transact-sql.md)

    [sp_altermessage](sp-altermessage-transact-sql.md)

    [sp_attach_db](sp-attach-db-transact-sql.md)

    [sp_attach_single_file_db](sp-attach-single-file-db-transact-sql.md)

    [sp_autostats](sp-autostats-transact-sql.md)

    [sp_bindefault](sp-bindefault-transact-sql.md)

    [sp_bindrule](sp-bindrule-transact-sql.md)

    [sp_bindsession](sp-bindsession-transact-sql.md)

    [sp_certify_removable](sp-certify-removable-transact-sql.md)

    [sp_clean_db_file_free_space](sp-clean-db-file-free-space-transact-sql.md)

    [sp_clean_db_free_space](sp-clean-db-free-space-transact-sql.md)

    [sp_configure](sp-configure-transact-sql.md)

    [sp_control_plan_guide](sp-control-plan-guide-transact-sql.md)

    [sp_create_plan_guide](sp-create-plan-guide-transact-sql.md)

    [sp_create_plan_guide_from_handle](sp-create-plan-guide-from-handle-transact-sql.md)

    [sp_create_removable](sp-create-removable-transact-sql.md)

    [sp_createstats](sp-createstats-transact-sql.md)

    [sp_cycle_errorlog](sp-cycle-errorlog-transact-sql.md)

    [sp_datatype_info](sp-datatype-info-transact-sql.md)

    [sp_db_increased_partitions](sp-db-increased-partitions.md)

    [sp_dbcmptlevel](sp-dbcmptlevel-transact-sql.md)

    [sp_dbmmonitoraddmonitoring](sp-dbmmonitoraddmonitoring-transact-sql.md)

    [sp_dbmmonitorchangealert](sp-dbmmonitorchangealert-transact-sql.md)

    [sp_dbmmonitorchangemonitoring](sp-dbmmonitorchangemonitoring-transact-sql.md)

    [sp_dbmmonitordropalert](sp-dbmmonitordropalert-transact-sql.md)

    [sp_dbmmonitordropmonitoring](sp-dbmmonitordropmonitoring-transact-sql.md)

    [sp_dbmmonitorhelpalert](sp-dbmmonitorhelpalert-transact-sql.md)

    [sp_dbmmonitorhelpmonitoring](sp-dbmmonitorhelpmonitoring-transact-sql.md)

    [sp_dbmmonitorresults](sp-dbmmonitorresults-transact-sql.md)

    [sp_delete_backuphistory](sp-delete-backuphistory-transact-sql.md)

    [sp_depends](sp-depends-transact-sql.md)

    [sp_describe_first_result_set](sp-describe-first-result-set-transact-sql.md)

    [sp_describe_undeclared_parameters](sp-describe-undeclared-parameters-transact-sql.md)

    [sp_detach_db](sp-detach-db-transact-sql.md)

    [sp_dropdevice](sp-dropdevice-transact-sql.md)

    [sp_dropextendedproc](sp-dropextendedproc-transact-sql.md)

    [sp_dropextendedproperty](sp-dropextendedproperty-transact-sql.md)

    [sp_dropmessage](sp-dropmessage-transact-sql.md)

    [sp_droptype](sp-droptype-transact-sql.md)

    [sp_execute](sp-execute-transact-sql.md)

    [sp_executesql](sp-executesql-transact-sql.md)

    [sp_get_endpoint_certificate](sp-get-endpoint-certificate-transact-sql.md)

    [sp_get_query_template](sp-get-query-template-transact-sql.md)

    [sp_getapplock](sp-getapplock-transact-sql.md)

    [sp_getbindtoken](sp-getbindtoken-transact-sql.md)
:::column-end:::
:::column:::
    [sp_help](sp-help-transact-sql.md)

    [sp_helpconstraint](sp-helpconstraint-transact-sql.md)

    [sp_helpdb](sp-helpdb-transact-sql.md)

    [sp_helpdevice](sp-helpdevice-transact-sql.md)

    [sp_helpextendedproc](sp-helpextendedproc-transact-sql.md)

    [sp_helpfile](sp-helpfile-transact-sql.md)

    [sp_helpfilegroup](sp-helpfilegroup-transact-sql.md)

    [sp_helpindex](sp-helpindex-transact-sql.md)

    [sp_helplanguage](sp-helplanguage-transact-sql.md)

    [sp_helpserver](sp-helpserver-transact-sql.md)

    [sp_helpsort](sp-helpsort-transact-sql.md)

    [sp_helpstats](sp-helpstats-transact-sql.md)

    [sp_helptext](sp-helptext-transact-sql.md)

    [sp_helptrigger](sp-helptrigger-transact-sql.md)

    [sp_indexoption](sp-indexoption-transact-sql.md)

    [sp_invalidate_textptr](sp-invalidate-textptr-transact-sql.md)

    [sp_lock](sp-lock-transact-sql.md)

    [sys.sp_merge_xtp_checkpoint_files](sys-sp-xtp-merge-checkpoint-files-transact-sql.md)

    [sp_monitor](sp-monitor-transact-sql.md)

    [sp_prepare](sp-prepare-transact-sql.md)

    [sp_prepexec](sp-prepexec-transact-sql.md)

    [sp_prepexecrpc](sp-prepexecrpc-transact-sql.md)

    [sp_procoption](sp-procoption-transact-sql.md)

    [sp_readerrorlog](sp-readerrorlog-transact-sql.md)

    [sp_recompile](sp-recompile-transact-sql.md)

    [sp_refreshview](sp-refreshview-transact-sql.md)

    [sp_releaseapplock](sp-releaseapplock-transact-sql.md)

    [sp_rename](sp-rename-transact-sql.md)

    [sp_renamedb](sp-renamedb-transact-sql.md)

    [sp_resetstatus](sp-resetstatus-transact-sql.md)

    [sp_sequence_get_range](sp-sequence-get-range-transact-sql.md)

    [sp_serveroption](sp-serveroption-transact-sql.md)

    [sp_set_session_context](sp-set-session-context-transact-sql.md)

    [sp_setnetname](sp-setnetname-transact-sql.md)

    [sp_settriggerorder](sp-settriggerorder-transact-sql.md)

    [sp_spaceused](sp-spaceused-transact-sql.md)

    [sp_tableoption](sp-tableoption-transact-sql.md)

    [sp_unbindefault](sp-unbindefault-transact-sql.md)

    [sp_unbindrule](sp-unbindrule-transact-sql.md)

    [sp_updateextendedproperty](sp-updateextendedproperty-transact-sql.md)

    [sp_updatestats](sp-updatestats-transact-sql.md)

    [sp_unprepare](sp-unprepare-transact-sql.md)

    [sp_validname](sp-validname-transact-sql.md)

    [sp_who](sp-who-transact-sql.md)

    [sys.sp_xtp_control_proc_exec_stats](sys-sp-xtp-control-proc-exec-stats-transact-sql.md)

    [sys.sp_flush_log](sys-sp-flush-log-transact-sql.md)

    [sys.sp_xtp_bind_db_resource_pool](sys-sp-xtp-bind-db-resource-pool-transact-sql.md)

    [sys.sp_xtp_control_query_exec_stats](sys-sp-xtp-control-query-exec-stats-transact-sql.md)

    [sys.sp_xtp_checkpoint_force_garbage_collection](sys-sp-xtp-checkpoint-force-garbage-collection-transact-sql.md)

    [sys.sp_xtp_force_gc](sys-sp-xtp-force-gc-transact-sql.md)

    [sys.sp_xtp_unbind_db_resource_pool](sys-sp-xtp-unbind-db-resource-pool-transact-sql.md)
:::column-end:::

:::row-end:::

Related content