Cannot find template file for the new query

Be carefull when using cleanup tools which remove empty files from your system.
The application I used deleted files with 0KB sizes.

Apparently it also deleted files like C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql which is 108 Bytes.

You can spot it from a 20 miles distance this is going to be major poo poo.
What was the impact removing that "SQLFile.sql" file?

I fired up SQL Server Management Studio and hit the New Query button and this popped up:

---------------------------
Microsoft SQL Server Management Studio
---------------------------
Cannot find template file for the new query ('C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql').
---------------------------
OK  
---------------------------

I created an empty sql script file and named it SQLFile.sql. That's it!

Sigh...

Published Thursday, March 19, 2009 6:00 PM by Steve
Filed under:

Comments

# Mak's guide to technical problems: Cannot find template file for the new query

Wednesday, September 02, 2009 10:20 PM by Mak's guide to technical problems: Cannot find template file for the new query

Pingback from  Mak's guide to technical problems: Cannot find template file for the new query

# Mak's guide to technical problems: Cannot find template file for the new query

Thursday, April 08, 2010 10:32 PM by Mak's guide to technical problems: Cannot find template file for the new query

Pingback from  Mak's guide to technical problems: Cannot find template file for the new query

# First computer - Computer electronic - Age computer first in knowledge print renaissance technology

Sunday, August 15, 2010 5:27 AM by First computer - Computer electronic - Age computer first in knowledge print renaissance technology

Pingback from  First computer - Computer electronic - Age computer first in knowledge print renaissance technology

# Freight general laredo trucking tx - Posada hotel - Laredo tx

Wednesday, September 08, 2010 1:20 PM by Freight general laredo trucking tx - Posada hotel - Laredo tx

Pingback from  Freight general laredo trucking tx - Posada hotel - Laredo tx

# University of south carolina graduate program - Graduate - University of south carolina

Wednesday, September 15, 2010 5:41 AM by University of south carolina graduate program - Graduate - University of south carolina

Pingback from  University of south carolina graduate program - Graduate - University of south carolina

# Regals plymouth meeting 14 conshohocken pa

Saturday, February 26, 2011 6:09 PM by Regals plymouth meeting 14 conshohocken pa

Pingback from  Regals plymouth meeting 14 conshohocken pa

# Cannot find template file for the new query | ??????

Thursday, May 05, 2011 9:36 AM by Cannot find template file for the new query | ??????

Pingback from  Cannot find template file for the new query | ??????