How can I make SQL Query Analyzer as my Registered Application

[essa2000]

Dears ;

I am using VSS for my .sql files and when I check out any file it is not opening in my SQL Query Analyser. I have to select the complete path of isqlw.exe from browser and then it opens those files in it. I don't want to select that path each time. I have done it before when I was not using Visual Studio .Net , now it opens those sql files in VS.NET editor.

Similarly , I want to open my Coldfusions files .cfm into Coldfusion editor instead of notepad.

There is an option in Check out pop up to select the registered application for particular files. But, I think when I installed VS.NET then my registered application for sql files is VS.NET instead of Query analyser.

So, is there a way to change my registered application to SQL Query Analyser.

Thanks in advance.



Muhammad Essa Mughal
Software Engineer
iLogic Inc.

 

[gavinhuet]

Hiya,

In your SourceSafe ini file there will be some entries which you can edit to force SourceSafe to open the files up
with certain applications.
Look for something like this:

.reg (Win) = notepad.exe
.vbp (Win) = notepad.exe
.vcp (Win) = notepad.exe
.mak (Win) = notepad.exe
.bat (Win) = notepad.exe
.cmd (Win) = notepad.exe
.sql (Win) = "isqlw.exe"

Just specify the full path for query analyser (ISQLW.exe) and it should all be fine.

-- Gavin

 

[essa2000]

Hi Gavin ;

Thanks for giving me nice help. I changed my ini files in my personal PC not on the Server where we saved our VSS database.

I wrote :

.sql (Win) = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe"

But , it is not working and my SQL Files are using VS.NET editor and opens in it.

Waiting for your response.

I also changed my file type from Windows Explorer and Tools menu. But , it does not work for me as well.
Essa

Muhammad Essa Mughal
Software Engineer
iLogic Inc.

 

[gavinhuet]

Muhammad,

See my relpy in the "Visual Basic(Microsoft) -VB.NET" forum - no need to have so many cross-posts...
thread796-766440

Gavin

 

[essa2000]

Hi Gavin ;

Thanks for your help , actually , It was an other problem , when we installed VS.NET it changes our registrey and make VS Editor as a registered application for .sql files as well. So, I had to change my registery which can be done thru options screen of Query Analyzer from Tools menu. We have to check first options which is for Set Query Analyzer as a Default editor for .sql files. so, I did that and I got the solutions.

Thanks for your kind help.

Essa

Muhammad Essa Mughal
Software Engineer
iLogic Inc.