Microsoft® SQL Server 2012 Unleashed

Policy-Based Management Best Practices

Following are some best practices to consider when implementing Policy-Based Management in SQL Server 2012:

When deploying Policy-Based Management in your environment, you should be very careful about using On Change Prevent. For example, a policy that prevents stored procedure creation with the sp_ prefix prevents the enabling of replication on a SQL Server.

When you create a policy that you want enforced on all user databases, you should place this policy in the default category so that all databases are ...