SSMS Solutions

Have you ever looked in amazement at your SQL guru who can whip up in a flash a fancy TSQL script to run?

Today I will share with you a super handy feature in SQL Server Management Studio (SSMS) called Solutions. Quite similar to Visual Studio solutions, you can create a solution(s) in SSMS with projects. Inside the projects you can then store all your favorite scripts.

Sounds great; so let me show you how in 5 minutes.

  1. OpenSSMS and press CTR+Shift+N.
      Now you will see this screen.

SQL Server Management Server Project

  1. Add a name.
  2. Hit ok.
  3. Back in SSMS you will notice Solution Explorer open with your new project added.
  4. Right click on “Queries”
  5. Select “New Query”

SSMS Project New Query


Congratulations on your first SSMS Project with a query.

Once you close SSMS it will prompt to save your solution and any open queries. Once confirmed it will save your scripts for use next time.

Now all you need to do is start build your own little pearls of wisdom and amaze the next future guru.

This entry was posted in SQL Server 2014 and tagged , . Bookmark the permalink.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s