Saturday, June 25, 2011

Single Click SQL Management Studio


Here is a simple way to avoid clicking on the inevitable SQL prompt when starting SQL Server Management studio.
On the shortcut simple add -S -d -E

For eample, on my PC, the shortcut is
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -S Manly -d master -E


Now when you click on SQL Server Management studio, it will connect automatically to the server/dbname. No more prompts to the server/dbname that you connect to every day.

3 comments:

Edafe Onerhime said...

Great tip, even better server name.

Nick Barclay said...

Also useful to add the -nosplash argument too. This stops the SSMS splash screen from displaying. Even more speed.

Justin King said...

Great tip, but I have issue where connection is made but object explorer doesn't have my server so I need to then connect to get it to display.