sys.sp_syspolicy_unsubscribe_from_policy_category

general

#stored-procedure

Description

The following example deletes a subscription to the policy category for the specified Policy-Based Management stored procedures (Transact-SQL) sp_syspolicy_subscribe_to_policy_category (Transact-SQL)

Syntax

USE
<database_name>;
GO
EXECUTE sys.sp_syspolicy_unsubscribe_from_policy_category
@policy_category = N
'Finance'
;
GO

Examples

Example 1

Finance

Example 2

USE
<database_name>;
GO
EXECUTE sys.sp_syspolicy_unsubscribe_from_policy_category
@policy_category = N
'Finance'
;
GO