An introduction to Policy-Based Management in SQL Server 2008: facets, conditions, policies, and how to create, evaluate and fix non-complying policies.
SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server
Use Policy Management in SQL Server 2008 to enforce rules, not just list them. A short tutorial that blocks any stored procedure created without the usp prefix.


