Export (0) Print
Expand All
Expand Minimize

Options (Text Editor/Editor Tab and Status Bar Page)

The Editor Tab and Status Bar Page lets you customize the information displayed by the SQL Server Management Studio Query Editors. You can specify the level of information displayed in the tab and status bar of the Query Editor window, and whether the status bar appears at the top or bottom of the editor window.

The editor tab and the status bar are available in all of the SQL Server Management Studio editors, but have different levels of functionality.

The Database Engine Query Editor can connect to a server group, in which case it opens connections to all the instances in the Server Group and can simultaneously run the same query on each connection. You can use this dialog to specify that the status bar has different colors when connected to multiple instances rather than one instance.To change the multi-server results options, use the Options (Query Results/SQL Server/Multi-Server) page.

Specifies the information that appears in the Query Editor status bar.

Display execution time

Includes the script execution time. The settings are as follows:

None

The status bar displays no time information.

End

The status bar displays the current time of day while the script is running. When the script completes, the display shows the time of day that the script completed.

Elapsed

The status bar displays the length of time that the script has been running. When the script completes, the display shows how much time was taken to run the script.

Include database name

Includes the name of the current database for the connection. When the query editor is first opened, this is the default database for the login. The database context can later be changed by using the Transact-SQL USE statement.

Include login name

Includes the login name.

Include row count

Includes a count of the rows that have been processed by the script that is currently executing.

Include server name

Includes the server name. For local connections, this is the instance name. For remote connections, this is the remote computer name and instance name.

Specifies the colors for items in the Query Editor status bar.

Group connections

Set the color of the status bar when the Query Editor has more than one connection.

Single server connections

Set the color of the status bar when the Query Editor has one connection.

Status bar location

Specifies the location of the status bar. The settings are as follows:

Top

The status bar appears at the top of the Query Editor window.

Bottom

The status bar appears at the bottom of the Query Editor window.

Specifies the text that appears in the tab at the top of a Query Editor window. If the text is too long to display, you can view the full string in a tooltip that is displayed if you hover over the tab.

Include database name

Includes the name of the current database for the connection. When the query editor is first opened, this is the default database for the login. The database context can later be changed by using the Transact-SQL USE statement.

Include file name

Includes the name of the file where the script is stored.

Include folder name

Includes the path of the folder where the script file is stored.

Include login name

Includes the login name.

Include server name

Includes the server name. For local connections, this is the instance name. For remote connections, this is the remote computer name and instance name.

Community Additions

ADD
Show:
© 2014 Microsoft