sp_syspolicy_subscribe_to_policy_category (Transact-SQL)

Applies to: SQL Server

Adds a policy category subscription for the specified database.

Syntax

syntaxsql

sp_syspolicy_subscribe_to_policy_category
    [ @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.

0 (success) or 1 (failure).

You must run sp_syspolicy_subscribe_to_policy_category in the context of the database where you want to add a policy category subscription.

Requires membership in the db_owner fixed database role.

The following example adds a subscription to the Finance policy category for the specified database.

SQL

USE <database_name>;
GO

EXEC sys.sp_syspolicy_subscribe_to_policy_category
    @policy_category = N'Finance';
GO