Pages

Tuesday, 5 October 2010

How to setup a MSSQL Server Management Studio (SSMS) 2008 New Query Template

It took me a small amount of Googling with Bing to find this post on Stack Overflow.

But it works for SQL 2008 r2 - apart from changing the paths slightly.

%Install Dir%:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\Sql\SQLFile.sql

I cant work out why is there nothing on MSDN about this cool feature?
Or why is not part of the SQL templates.


References:
http://sqlsoundings.blogspot.com/2010/03/using-ssms-templates-for-fun-and-profit.html
http://msdn.microsoft.com/en-us/library/ms174169.aspx
http://stackoverflow.com/questions/593047/mssql-server-management-studio-ssms-2005-new-query-template