Tips ‘N’ Tricks – SSMS – Shortcut to Invoke SQL Server Management Studio

Following are the two approaches to invoke SQL Server Management Studio (SSMS) in various versions of SQL Server.

Regular Approach (4 Steps)

  • Click on Start
  • Go to All Programs
  • Go to Microsoft SQL Server <<Version>> (like Microsoft SQL Server 2008 R2)
  • Click on SQL Server Management Studio

Shortcut Approach (3 Steps)

  • Click on Start > Click on Run… (or alternatively press Windows + R)
  • Type the following
    • sqlwb (for SSMS 2005)
    • ssms (for SSMS 2008/2008 R2/2012)
  • Click on OK or Hit Enter

This simple 3 step process launches SQL Server Management Studio (SSMS) for corresponding version of SQL Server).

If you know of any other interesting shortcuts, then share it by leaving a comment below.


Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 1, 2012, in SQL Server, SSMS, SSMS Tips, Tips 'N' Tricks and tagged , , , , . Bookmark the permalink. 2 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: