Skip to content

Latest commit

 

History

History
79 lines (57 loc) · 2.45 KB

sp-syspolicy-delete-policy-category-subscription-transact-sql.md

File metadata and controls

79 lines (57 loc) · 2.45 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_syspolicy_delete_policy_category_subscription (Transact-SQL)
Deletes a policy category subscription for a specific database.
VanMSFT
vanto
randolphwest
06/26/2023
sql
system-objects
reference
sp_syspolicy_delete_policy_category_subscription_TSQL
sp_syspolicy_delete_policy_category_subscription
sp_syspolicy_delete_policy_category_subscription
TSQL

sp_syspolicy_delete_policy_category_subscription (Transact-SQL)

[!INCLUDE SQL Server]

Deletes a policy category subscription for a specific database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_syspolicy_delete_policy_category_subscription
    [ @policy_category_subscription_id = ] policy_category_subscription_id
[ ; ]

Arguments

[ @policy_category_subscription_id = ] policy_category_subscription_id

The identifier for the policy category subscription. @policy_category_subscription_id is int.

Return code values

0 (success) or 1 (failure).

Remarks

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

You can't delete a policy category subscription when the subscription is mandated.

Permissions

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;

Examples

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;
GO

Related content