You are here: Re: SQL Server 2005 Opening Script File Problem « MsSQL Server « IT news, forums, messages
Re: SQL Server 2005 Opening Script File Problem

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация