How to Enforce SQL Server Naming Conventions

Want to enforce naming standards in your SQL Server environment? For example, do you have a standard for naming stored procedures that you need to enforce?

With SQL Server 2008 R2 policy-based management, this is now possible. Create a “On Change Prevent” policy using the Stored Procedure facet and the @NAME field.

Pandian Sathappan has the full rundown on all of the steps you need to create this here. It’s an excellent and thorough article and I highly recommend it.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s