Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I make SQL Query Analyzer as my Registered Application

Status
Not open for further replies.
essa2000

essa2000

Programmer
Joined
Dec 6, 2000
Messages
299
Location
CA
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.
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Muhammad,

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

Gavin
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

yossid
  • Locked
  • Question Question
Where does VSS store file associations?
Replies
1
Views
1K
JeffBe
JeffBe
lincoln311219
  • Locked
  • Question Question
how to work with working folder and dev envronment
Replies
0
Views
1K
lincoln311219
lincoln311219
srmonson
  • Locked
  • Question Question
What Version of SourceSafe is my database?
Replies
0
Views
974
srmonson
srmonson
srmonson
  • Locked
  • Question Question
Copy current databse to new server.. HOW?
Replies
0
Views
945
srmonson
srmonson
LFCfan
  • Locked
  • Question Question
VS thinks I am my colleague
Replies
1
Views
360
LFCfan
LFCfan

Part and Inventory Search

Sponsor

Back
Top