This topic describes how to view all of the Policy-Based Management facets applied to a specific SQL Server object in SQL Server 2017 by using SQL Server Management Studio.
In This Topic
Before you begin:
To view all of the facets in an object, using:
Requires membership in the PolicyAdministratorRole role in the msdb database.
To view all of the facets in an object
In Object Explorer, right-click an instance of SQL Server, instance object, database, or database object, and then click Facets.
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.
When finished, click OK.