1 out of 1 rated this helpful - Rate this topic

Policy-Based Management Stored Procedures (Transact-SQL)

SQL Server 2008

SQL Server 2008 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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions