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

Tadaaaa!

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.

Advertisements
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:

WordPress.com Logo

You are commenting using your WordPress.com 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