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
On the shortcut simple add -S
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.
Great tip, even better server name.
ReplyDeleteAlso useful to add the -nosplash argument too. This stops the SSMS splash screen from displaying. Even more speed.
ReplyDeleteGreat 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