SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

SSMS Connection Information

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


Filed under: Documentation, Microsoft SQL Server, SQLServerPedia Syndication, SSMS Tagged: connections, microsoft sql server, SSMS

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Comments

Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...