O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, 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

Ensuring Object Naming Conventions

Your company may have standards for naming objects. For example, stored procedures must start with the prefix usp, tables must start with the prefix tbl, and functions must start with the prefix ufn. Policy-Based Management can be used to ensure that all objects are compliant with this policy. This policy can be implemented to execute as On Change Prevent, which prevents the creation of such noncompliant objects.

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