SSMS Connection Information

Leave a comment

September 28, 2015 by Kenneth Fisher

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it can be kind of hard to remember which connection is which. Fortunately all of the information you need is readily available.

Connections in the Object Explorer

SSMSConnectionInfo

Notice that for each connection there is the instance name (red box), the version of SQL Server (green box) and the name of the login connected (orange box).

Connections in the query window

There are few places we can find information about query window connections.

The Status Bar

SSMSConnectionInfo2

  1. Number of connections in this query window. (Yes you can have more than one.)
  2. Instance name and version.
  3. Login name that made the connection.
  4. Database connected to.
  5. How long the last query run took.
  6. How many rows were returned by the last query run.

 
The Tab heading

SSMSConnectionInfo4

Here we have the query/file name (red box), login name (orange box) and the SPID (green box). This isn’t my favorite place to find connection information because it abreviates so much but it does have the SPID which is highly useful.

Another way to see the tab information is the small arrow dropdown in the top right corner of the query tabs. This drop down lists the tabs currently open.

SSMSConnectionInfo5

Basically it’s the same information as the tabs but you can see more of them at once.

Changing the information

And of course in the settings you can change the information shown in the status bar and in the tab heading.

SSMSConnectionInfo3

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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: