Customise SSMS query tab information

Aim: To remove unnecessary information from SSMS query tabs, to make them more useful & easier to read.

I was reminded of this very useful customisation in SSMS the other day while reviewing Brent Ozar training notes.

By default, SSMS includes the file (query), server, database & login names in the query tab. Unless these names are only a few characters long, this usually results in truncation of the information, making it less than useful. You have to hover your cursor over the query tab to see the full string.

01_default_tab_info

To remove unnecessary information (e.g. server & login names*), open Options from the Tools menu & navigate to “Editor Tab and Status Bar” under Text Editor. In the right-hand window, scroll to the “Tab Text” section at the bottom. By default, all four options are set to True. Set the server & login names to False.

02_options_editor_tab

After making the changes, any queries that are opened will only contain the file & database names.

03_new_tab_info

* Server, database & login names can all be found on the Status Bar which is located at the bottom of the query window (by default). I like to leave the database name in the tab as this can be useful when visually scanning multiple tabs open at the same time in SSMS.

Advertisements

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

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: