Pro SQL Server 2008 Policy-Based Management

Chapter 2. Creating Policies

Before you can apply and enforce policies, you need to create them, because no policies are implemented by default in SQL Server 2008. You can create a policy in several ways, such as manually from scratch, using Transact SQL (T-SQL), exporting a policy based on your current SQL Server configuration, or even importing one of Microsoft's policies based on best practices. In addition, by using advanced conditions when creating a policy, you will see that there is almost no limit to the types of policies you can create for your environment. As you start creating policies, you will also find it helpful to create categories, which allow you group and manage similar policies.

Manually Creating Policies

In order to explain ...