Export (0) Print
Expand All

Subscribe or Unsubscribe a Database to a Policy Category

This topic describes how to subscribe or unsubscribe a database to a policy category.in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL.

In This Topic

Security

Permissions

Requires membership in the db_owner fixed database role.

Arrow icon used with Back to Top link [Top]

To subscribe or unsubscribe a database to a policy category

  1. In Object Explorer, click the plus sign to expand the server that contains the database wherein you want to manage category subscriptions.

  2. Click the plus sign to expand the Databases folder.

  3. Right-click the database wherein you want to manage category subscriptions, point to Policies, and select Categories

    The following options are available in the Categories dialog box:

    Expand column

    Click to expand a policy category. This lists all the policies that are included in the category.

    Name

    The name of the policy category.

    Subscribed

    Indicates whether the target has subscribed to the policy category. If this check box is disabled, the policy category is set for Mandate Database Subscriptions. This means that the policy category applies to all databases on the server.

    Policy

    When policy groups are expanded, displays the policies in the policy category.

    Enabled

    Indicates whether the policies are enabled or disabled.

    Execution Mode

    Displays the execution mode of the policy.

    History

    Click the View History hyperlink to open the Log File Viewer to see the policy history.

  4. To subscribe to a Policy-Based Management category, select the category's check box under the Subscribed column. To unsubscribe from a category, clear the check box.

  5. When finished, click OK.

Arrow icon used with Back to Top link [Top]

To subscribe a database to a policy category

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    USE AdventureWorks2012;
    -- Adds a subscription to the 'Finance' policy category for the AdventureWorks2012 database.
    EXEC sys.sp_syspolicy_subscribe_to_policy_category @policy_category = N'Finance';
    GO
    

For more information, see sp_syspolicy_subscribe_to_policy_category (Transact-SQL).

To unsubscribe a database to a policy category

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    USE AdventureWorks2012;
    -- Deletes a subscription to the 'Finance' policy category for the AdventureWorks2012 database.
    EXEC sys.sp_syspolicy_unsubscribe_from_policy_category @policy_category = N'Finance';
    GO
    

For more information, see sp_syspolicy_unsubscribe_from_policy_category (Transact-SQL).

Arrow icon used with Back to Top link [Top]

Community Additions

ADD
Show:
© 2014 Microsoft