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.