sp_syspolicy_delete_policy_category_subscription (Transact-SQL)
Applies to:
SQL Server
Deletes a policy category subscription for a specific database.
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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho