Open SQL server with one click

Hi

Before reading this post, tell me how your opening SQL server, I mean how many steps its taking… just count… may be from 3-4 clicks… and for opening object explored 2 more .. And opening new query window for a particular database 2 more…

Now I will tell how you can open SQL server (with object explorer, new query window with selected DB) in one lick.

You know how to open it normal way, i mean from Run command, it is “sqlwb”(for sql server 2005) and “ssms”(for sql server 2008).

Open Run command, type:

sqlwb -S ServerName -d DataBaseName -U UserName -p Password

e.g:

sqlwb -S TestServer -d dummyDatabse -U Username_test -p myDummyPassword

To get help for these commands and more type “sqlwb /?” in run command.(“ssms /?” for 2008 sql server).

Happy coding…!!!