Microsoft® SQL Server® 2012 Bible

536

Part V: Enterprise Data Management

FIGURE 20-3

The View Facets dialog, opened from any object’s context menu, presents a browsable UI of

every facet and property that can apply to that type of object, and even can export a new

policy to match the current object’s settings.

To construct a condition that tests a database’s autoshrink property, the expression would

use the database facet and the @AutoShrink property, as shown in Figure 20-4. In this

case the full expression is:

@AutoShrink = False

Best Practice

Think of condition expressions as positive statements. Instead of thinking, “No database should be

set to autoshrink,” think “All databases should have autoshrink set to False.”

c20.indd 536c20.indd 536 7/30/2012 5:45:10 PM7/30/2012 5:45:10 PM

http://www.it-ebooks.info