SQL Templates (in SQL Server Management Studio)

Credit goes to the Cincinnati SQL Server User’s Group/Phil Japikse for the following tip.  Two things of interest in this post.  Ability to create Sql Templates within SQL Server Management Studio and SQL to find objects named like ‘%here%’ across all objects in a database. USE GO SELECT OBJECT_NAME(OBJECT_ID) FROM sys.sql_modules WHERE definition like '%