Search code examples
sql-serverssms

In SSMS, how do I change a SQL query window's tab name?


I want to know how to change the tab name of a SQL query window:

enter image description here

Instead of SQLQuery8.sql…Registry(sa(51)), I would like to have a custom caption.

If the query window has a very title, I can only open 3 windows at a time. I want to open more than 10 windows. So I need to change the query window's name to something very short, something like Q1, Q2, etc.

How can I change this?


Solution

  • In SSMS, go to Tools > Options > Text Editor > Editor Tab and Status Bar.

    You can manage some options of tab text, as shown in the picture below.
    (for example don't include db name, file name, login name and/or server name).

    SQL Server Options