Export (0) Print
Expand All

sp_syspolicy_delete_policy_category_subscription (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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;

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft