Shortcut: Change the Status Bar in SQL Server Management Studio (SSMS)
The status bar at the bottom of a query window in SQL Server Management Studio contains a wealth of information in its default configuration.
The bottom left shows the connection state:
I’ll talk about connection management more in a later post. The bottom right also shows quite a bit:
In this case, it’s showing me that I’m connected to a server called SDUPROD; it’s running v14 of SQL Server (ie: SQL Server 2017); I’m logged on as GREGP50\Greg; my spid (or session ID) is 68; and I’m connected to the master database.
2018-02-22