Posted by Erland Sommarskog on 08/19/06 22:26

(mollyf@hotmail.com) writes:
> Yes it happens when I double-click on the file in Explorer and within
> Mgmt Studio. All of my .sql files have had the little icon thing
> associated with them ever since I installed SQL Server 2005 but I can
> only open the files I created myself in Mgmt Studio--not the ones that
> my coworker gave me. On Monday I'm going to have my other coworker
> create a script and put it on the network drive for me to access (my
> other coworker e-mailed the others) and I'm going to have her try
> opening a script coming from my machine.

Try this. From the menu in Mgmt Studio, select File->Open->File. Navigate
to the directory where you have one of these suspect files. Select such
a file, and then click the arrow on the left of the Open button and
Select Open With.

You now get a window that presents you with a whole range of editors,
and on the top one is listed by default. Which editor is this?

Interesting enough, Notedpad does appear in this list, although I
don't get it as the default for any file.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]