View Facets in SQL Server

Facets are database objects or server and other, such as a table, a stored procedure, a login and many more. Each facet has a set of properties on which the conditions can be created. In this article I will explain how to view facets in SQL Server.Overview

A Policy-Based Management facet is a set of logical properties that are related to an area of management interest. SQL Server includes several predefined facets. For example, the Surface Area Configuration facet defines, as properties, the features that are off by default.

Getting Started

1. Open Management Studio, start by connecting to the server.

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

right click menu facets

3. In this dialog box, you will have access to view the facets of the item selected. Click “Ok” once you are done with the facet configuration:

view facets dialog box

4. In this dialog you will see the following options:

  • Facet: The name of the currently selected facet.
  • Description: Provides a general description of the facet.
  • Facet properties: Displays the names and settings of the facet properties.
  • Export Current State as Policy: Click to export the described state of the facet properties as a new policy in an XML file.

What are the uses for the facets?

Facets allows you to implement one or more management facets. Facets can be configured  in one instance of SQL Server, copy the state of the facet in a local file, and import the file into another instance of SQL Server as a management policy.

This concludes View facets in SQL Server.

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , | Posted under ASP .NET 4.0 | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *