Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Status Bar Information

SQL Server 2000

SQL Query Analyzer has five status bars, which provide information about activity or connections in SQL Query Analyzer windows.

SQL Query Analyzer window - The status bar in the SQL Query Analyzer application window displays:

  • General information about activity in the window, including descriptions of selected menu commands.

  • Total number of connections consumed by the current user.

  • CAPS lock setting.

  • NUM lock setting.

  • Insert/Overwrite mode setting.

Query window - The Query window status bar displays:

  • Status of the current operation.

  • Name of the current database server.

  • Current user and server process identifier (ID).

  • Name of the current database.

  • Amount of execution time for the last query or the currently executing query.

  • Number of rows returned. When results are displayed in a grid and the Results pane is the active pane, the grid number is also shown.

  • Current position of the insert cursor in the window. When results are displayed in a grid and the Results pane is the active pane, the position of the current grid cell is shown.

Object Search - The Object Search window status bar displays:

  • Status of the current operation.

  • Name of the current database server.

  • Current user and server process ID.

  • Amount of search time for the last search or currently executing search.

  • Number of rows in the search result.

Open Table window - The Open Table window status bar displays:

  • Name of the current database server.

  • Current user and server process ID.

  • Name of the current database.

  • Number of rows returned.

  • Position of the current grid cell.

T-SQL Debugger - The Transact-SQL Debugger window status bar displays:

  • Status of the current operation.

  • Connected.

  • Automatic rollback of transactions.

  • Current position of the insert cursor in the window.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.