Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Deletes a policy category subscription for the current database.
Transact-SQL syntax conventions
Syntax
sp_syspolicy_unsubscribe_from_policy_category
[ @policy_category = ] N'policy_category'
[ ; ]
Arguments
[ @policy_category = ] N'policy_category'
The name of the policy category subscription that you want to delete. policy_category is sysname, and is required.
To obtain values for @policy_category, query the msdb.dbo.syspolicy_policy_categories system view.
Return code values
0 (success) or 1 (failure).
Remarks
You must run sp_syspolicy_unsubscribe_from_policy_category in the context of the database where you want to remove a policy category subscription.
Permissions
Requires membership in the db_owner fixed database role.
Examples
The following example deletes a subscription to the Finance policy category for the specified database.
USE <database_name>;
GO
EXEC sys.sp_syspolicy_unsubscribe_from_policy_category
@policy_category = N'Finance';
GO