O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Policy

After creating the condition or conditions, you need to create the policy. The policy is a standard that can be enforced on one or more SQL Server instances, systems, server objects, databases, or database objects. Follow these steps to create a policy with SQL Server Management Studio:

1. In Object Explorer, expand the Management folder, expand the Policy Management folder, and then click on Policies.

2. Right-click on the Policies folder and select New Policy.

3. On the General tab of the Create New Policy dialog, enter a name for the new policy, such as Check Table Naming Conventions.

4. In the Check Condition drop-down box, select a condition, such as the one created in the previous example, or select New to generate a new ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required