Posted by mollyf on 08/18/06 13:26

Erland Sommarskog wrote:
<snip>
> First thing is to go the Windows Explorer, and in the menu pick
> Tools->Folder Options, and there to go the View tab. Make sure that
> "Hide file extentions for known file types" is unchecked. (Overall, any
> good programmer who gets a new box should always go this dialog and
> change this setting and a few more which have stupid defaults.)
>
> Now you can see which extensions, you coworker's file has. In the next
> tab in Folder Options, you can check the association for that file type.
> You can also change associations from Tools->Customise->Text Editor in
> Mgmt Studio.
>

Like I said in my original post--the application associated with the
file is SQL Server 2005 (has the new icon associated with it and has
the file extension of .sql). It was the very first thing I checked
when it happened the first time.

I went and did what you said in Mgmt Studio and still no change--the
file opened up in Notepad.

Another thing that I noticed is that any queries that I wrote for SQL
2000, I can open them in Mgmt Studio but not the ones created by my
coworker. The other gal who works in our department hasn't run into
the same problems that I have. I copied and pasted the scripts written
by my coworker into the query window and ran them and they ran perfect
so it would appear that it's not a permissions issue or anything like
that.

Thanks.

Molly J. Fagan

[Back to original message]