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.

Want to learn more about SSMS? Check out this Pluralsight course.
Use SqlSmash to write maintainable SQL scripts, understand code faster and navigate around easily in SSMS.