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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.