SSMS Tips and Tricks

Productivity Driven Development

Customize Startup Using Command Line Parameters

| Comments

Do you work with the same server everyday, or perhaps you want more control over SSMS startup. SSMS supports a bunch of command line options. Just go to a command line and type

ssms -?

And you’ll see the available command line options:

So if I want to connect to my local server and the database Adventureworks2012, I can type

ssms -S . -E -d adventureworks2012

If you don’t like using the command line, you can always create a shortcut pointing to SSMS on your desktop, and provide the parameters there.

Use SqlSmash to write maintainable SQL scripts, understand code faster and navigate around easily in SSMS.