View the Policy-Based Management Facets on a SQL Server Object

This topic describes how to view the state of a Policy-Based Management facet in SQL Server 2012 by using SQL Server Management Studio.

In This Topic

• Before you begin:

  Security

• To view the state of a facet, using:

  SQL Server Management Studio

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

[Top]

Using SQL Server Management Studio

To view the state of a facet

1. In Object Explorer, right-click an instance of SQL Server, instance object, database, or database object, and then click Facets.

2. In the View Facets – object_name dialog box, in the Facet list, select a facet to view its properties. For more information on the available options in this dialog box, see View Facets Dialog Box.

3. When finished, click OK.

[Top]