Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

Policy-Based Management Stored Procedures (Transact-SQL)

SQL Server supports the following system stored procedures that are used for Policy-Based Management.

Important

Only the Policy-Based Management stored procedures that are documented in SQL Server Books Online are supported. Undocumented stored procedures are used by internal Policy-Based Management components and should not be used to administer Policy-Based Management.

sp_syspolicy_add_policy_category

sp_syspolicy_rename_policy_category

sp_syspolicy_add_policy_category_subscription

sp_syspolicy_repair_policy_automation

sp_syspolicy_configure

sp_syspolicy_set_config_enabled

sp_syspolicy_delete_policy_category

sp_syspolicy_set_config_history_retention

sp_syspolicy_delete_policy_category_subscription

sp_syspolicy_set_log_on_success

sp_syspolicy_delete_policy_execution_history

sp_syspolicy_subscribe_to_policy_category

sp_syspolicy_purge_health_state

sp_syspolicy_unsubscribe_from_policy_category

sp_syspolicy_purge_history

sp_syspolicy_update_policy_category

sp_syspolicy_rename_condition

sp_syspolicy_update_policy_category_subscription

sp_syspolicy_rename_policy

 

See Also

Concepts

Administering Servers by Using Policy-Based Management


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026