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
Posted Sunday, November 23, 2008 9:36 PM by cabhilash | with no comments
Filed under:

.NET Framework V2.0 Obsolete API List

With the release of .Net framework 3.0 & 3.5 a lot API in .Net 2.0 has become obsolete.

I found two excellent links in MSDN which gives a comphrensive list of all the obsolete API's of .Net 2.0

  • The Obsoleted Types count is the number of obsoleted types found in the assembly/namespace.
  • The Obsoleted Members count is the number of obsoleted members not contained in an obsoleted type. If a type is obsolete, it's members are not counted in this value.

Obsolete List: By Assembly

Obsolete List: By Namespace

 

 

Posted Friday, January 25, 2008 8:18 AM by cabhilash | with no comments
Filed under:
More Posts