Microsoft® SQL Server® 2012 Bible

538

Part V: Enterprise Data Management

select * from msdb.dbo.syspolicy_conditions

FIGURE 20-5

Use the Advanced Edit dialog to create each side of the expression. In this case it shows the

left side of the AutoShrink expression.

To build advanced conditions that check factors other than the built-in facets, look into the executeSQL and

executeWMI functions.

Creating Policies

If the facet property is the fact and the condition the brain, the policy is the muscle.

Policies defi ne how and where the condition is applied and enforced.

You can create a new policy using the New Policy menu item in Object Explorer’s

Management ➪ Policy Management ➪ Policies and then selecting the New Policy option

from the context menu. Alternatively, you can go to the File menu, browse to the New

submenu, and then select Policy from the list. The Create New Policy dialog, as shown in

Figure 20-6, has a general page and a description page.

c20.indd 538c20.indd 538 7/30/2012 5:45:12 PM7/30/2012 5:45:12 PM

http://www.it-ebooks.info