sp_syspolicy_delete_policy_category_subscription (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Deletes a policy category subscription for a specific database.

|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions


sp_syspolicy_delete_policy_category_subscription [ @policy_category_subscription_id = ] policy_category_subscription_id  


[ @policy_category_subscription_id= ] policy_category_subscription_id
Is the identifier for the policy category subscription. policy_category_subscription_id is int.

Return Code Values

0 (success) or 1 (failure)


You must run sp_syspolicy_delete_policy_category_subscription in the context of the msdb system database.

You cannot delete a policy category subscription when the subscription is mandated.


This stored procedure runs in the context of the current owner of the stored procedure.

To obtain values for policy_category_subscription_id, you can use the following query:

SELECT a.policy_category_subscription_id, a.target_object, b.name AS category_name  
FROM msdb.dbo.syspolicy_policy_category_subscriptions AS a  
INNER JOIN msdb.dbo.syspolicy_policy_categories AS b  
ON a.policy_category_id = b.policy_category_id;  


The following example deletes a policy category subscription with an ID of 1.

EXEC msdb.dbo.sp_syspolicy_delete_policy_category_subscription @policy_category_subscription_id = 1;  


See Also

Policy-Based Management Stored Procedures (Transact-SQL)
sp_syspolicy_update_policy_category_subscription (Transact-SQL)