sp_syspolicy_subscribe_to_policy_category (Transact-SQL)
Applies to: SQL Server
Adds a policy category subscription for the specified database.
Transact-SQL syntax conventions
Syntax
sp_syspolicy_subscribe_to_policy_category
[ @policy_category = ] N'policy_category'
[ ; ]
Arguments
[ @policy_category = ] N'policy_category'
The name of the policy category that you want the database to subscribe to. @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_subscribe_to_policy_category
in the context of the database where you want to add a policy category subscription.
Permissions
Requires membership in the db_owner fixed database role.
Examples
The following example adds a subscription to the Finance
policy category for the specified database.
USE <database_name>;
GO
EXEC sys.sp_syspolicy_subscribe_to_policy_category
@policy_category = N'Finance';
GO