Any suggestions? Export (0) Print
Expand All

sp_syspolicy_subscribe_to_policy_category (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

Adds a policy category subscription for the specified database.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_syspolicy_subscribe_to_policy_category [ @policy_category = ] 'policy_category'

[ @policy_category = ] 'policy_category'

Is 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.

USE <database_name>;

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


Community Additions

© 2016 Microsoft