SQL Server 2008 has a new feature called Policy Based Management, also know as Declarative Management Framework (DMF), to tackle the problem of standardizing your SQL server instance. Although Policy Based Management can be used just to alert an administrator when an object is out of compliance, depending upon the type of policy, you can also enforce compliance by preventing changes that would violate a policy.
Policy Based Management introduces the following new objects that are used to design and check for compliance:
- Facts
- Conditions
- Policies
- Policy Targets
- Policy Categories
For more information click here
Varinder Sandhu 