1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Creating a Distributed Management Framework Policy


Creating a Distributed Management Framework Policy
Policy objects specify the conditions you wish to enforce against database targets using the Distributed Management Framework (DMF). In this tutorial, we create a DMF policy that enforces the stored procedure naming convention condition we created together in the previous step.
Difficulty: Average
Time Required: 15 minutes

Here's How:

  1. Open SQL Server Management Studio (SSMS) and expand the Management folder.
  2. Expand the Policy folder underneath the Management folder.
  3. Right-click on the Policies folder and select New Policy from the pop-up menu.
  4. Provide a name for your policy by typing it into the Name text box.
  5. Choose the condition you want to enforce from the drop-down menu. If you haven't already created a condition, read creating DMF conditions.
  6. Choose the evaluation mode you wish to use from the drop-down menu. On Demand mode does not perform any automated policy enforcement and allows you to run the policy at your discretion. On Schedule mode allows you to create a schedule for policy execution. On Change - Log Only mode creates a log entry whenever the database changes in a manner that violates the policy. On Change - Prevent mode verifies that all changes to the database comply with the policy before permitting the change.
  7. Click the OK button to create the policy.


  1. If you use DMF policies, be sure to back up the msdb database, as SQL Server stores them there.

What You Need

  • SQL Server 2008 or later
  • SQL Server Management Studio
Related Video
iMovie Slideshow
  1. About.com
  2. Technology
  3. Databases
  4. SQL Server
  5. How to Create a DMF Policy

©2014 About.com. All rights reserved.