534
Part V: Enterprise Data Management
In database design terminology, there’s a many-to-many relationship between SQL Server
object types and properties. For example, database facet properties apply only to data-
bases, but the term facet can apply to 84 different types of SQL Server objects ranging from
ApplicationRoles to XmlSchemaCollections, including databases.The Facet collection is the associative table between SQL Server object types and
properties.You can open a facet by double-clicking the facet or by selecting the Properties option in
its context menu. The Facet Properties dialog, as shown in Figure 20-2, has three pages:■ (^) General: Describes the property, lists the type of SQL Server objects to which the
facet properties may apply, and lists the facet’s properties.
■ (^) Dependent Policies: Lists the policies that use any dependent conditions of the
facet.
■ (^) Dependent Conditions: Lists the conditions that use any property from the facet.
FIGURE 20-2
The Facet Properties’ General page lists of all the facet properties and their descriptions. In
this case, it’s showing the properties for the Database facet.
c20.indd 534c20.indd 534 7/30/2012 5:45:10 PM7/30/2012 5:45:10 PM
http://www.it-ebooks.info