Skip to main content

Posts

Showing posts from November, 2008

SQL Server Management Studio query template

Last day I was working on SQL server and I got this strange error --------------------------- Microsoft SQL Server Management Studio --------------------------- Cannot find template file for the new query ('C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql'). --------------------------- OK At first I thought my SQl server installation was corrupt. I changed few settings, tried to repair but no use. Solution: Actually the solution was very simple. I just created an empty file SQLFile.sql in the designated folder and then it started working. Now this gave me a new idea. I could add my own template and every time I open SSMS I will get this template. Phew