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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru