SHORT CUT KEY TO OPEN QUERY ANALYZER FROM "RUN" PROMPT

Question

SHORT CUT KEY TO OPEN QUERY ANALYZER FROM "RUN" PROMPT

hunt

Right there with Babe

Points: 780
More actions
August 8, 2008 at 1:21 am

#195626

Hi,
I am new to SQLSERVER .
Can any one tell me shortcut to open query analyzer from RUN command prompt
without any clicks of mouse
thanks
sarat 🙂
Curious about SQL

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

sarat_1030 (8/8/2008)
Hi,
I am new to SQLSERVER .
Can any one tell me shortcut to open query analyzer from RUN command prompt
without any clicks of mouse

run:

isqlw

You may actually want to consider adding a shortcut to your desktop/wherever though.

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Abhijit More SSCertifiable Points: 6897 More actions · Answer 2

if you are using SQL Server 2005

then type sqlwb in cmd prompt.

Abhijit - http://abhijitmore.wordpress.com

er.soundararajan-800293 Old Hand Points: 321 More actions · Answer 3

Hi there,

You can use Sqlwb to open management studio. But sometimes if you install sqlserver and Management studio express seperatly you have to use ssmsee instead.

The best way is to add the path \Tools\Binn\VSShell\Common7\IDE (Ex: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE) to the environment variables and proceed. Add them in the machine path variables and not the users path variables.

hunt Right there with Babe Points: 780 More actions · Answer 4

hunt

Right there with Babe

Points: 780

August 12, 2008 at 5:12 am

#856582

thanks u all

thanks
sarat 🙂
Curious about SQL

Venkatesan Prabu SSCommitted Points: 1892 More actions · Answer 5

Any way I need to add more value add to this topic...

For opening sql server window from run..... sqlwb

For SSIS or visual studio .... use devenv

Thanks and Regards,
Venkatesan Prabu, 😛
My Blog:

http://venkattechnicalblog.blogspot.com/

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 6

And, just to make things interesting - in SQL Server 2008 they changed it to: ssms.exe

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 7

For most of these you can add -nosplash to eliminate the splash screen. Loads a few seconds faster. For instance:

sqlwb -nosplash

K. Brian Kelley
@kbriankelley