HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Reset the numbering at the tabs of the Microsoft SQL Server Management Studio

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
theserversqlmicrosoftresetmanagementstudiotabsnumbering

Problem

I notice there are some numbering on the tab of each new query (such as the number 52, 56, 57 and 58 as shown in the following pictures)

What does these numbers means and is it possible to reset to the first original values?

Solution

The numbers represent the process id of the session associated with that tab - as every time you open a new tab it opens a new connection to SQL Server for you. They are not necessarily sequential but they can be. If you run the following command you should be able to see an entry for each of the tabs/connections that you have open:

select * from sys.dm_exec_sessions


I hope this helps you.

Code Snippets

select * from sys.dm_exec_sessions

Context

StackExchange Database Administrators Q#24003, answer score: 4

Revisions (0)

No revisions yet.