×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How can I make SQL Query Analyzer as my Registered Application

How can I make SQL Query Analyzer as my Registered Application

How can I make SQL Query Analyzer as my Registered Application

(OP)
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.

RE: How can I make SQL Query Analyzer as my Registered Application

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

RE: How can I make SQL Query Analyzer as my Registered Application

(OP)
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.

RE: How can I make SQL Query Analyzer as my Registered Application

Muhammad,

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

Gavin

RE: How can I make SQL Query Analyzer as my Registered Application

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close