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.
at

3 comments:

  1. UnknownJune 27, 2011 at 5:24 PM

    Great tip, even better server name.

    ReplyDelete
  2. Nick BarclayJune 28, 2011 at 1:39 AM

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

    ReplyDelete
  3. Justin KingJuly 5, 2011 at 10:09 AM

    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.

    ReplyDelete