Export (0) Print
Expand All

Status Bar (Database Engine Query Editor)

The status bar of Database Engine Query Editor windows can be color coded to indicate which instance of the Database Engine each window is connected to.

  1. Before you begin: Status Bar Colors

  2. To set a server status color in: Object Explorer, Registered Server

  3. To use a status color: Open Query Editor Using a Server Color, Open a Query Editor Specifying a Status Color

You can associate a status bar color with a specific server node in either Object Explorer or Registered Servers. The colors can only be specified for server nodes connected to an instance of the Database Engine, not server nodes for other SQL Server technologies. You can also specify a custom status bar color each time you connect a new Database Engine Query Editor window to an instance of the Database Engine. You can then open a query editor window using either the status color defined for the server node, or specify a unique color for that editor window.

Setting a custom status bar color for a server node in Object Explorer must be done when making the connection. To change the color associated with an existing server node, you must disconnect and then reconnect specifying the new color.

To set a server status color in Object Explorer

  1. In Object Explorer, select the Connect button and then select Database Engine….

  2. On the Connect to Server dialog, select Options >>.

  3. Select the Use custom color check box.

  4. To select the color, select the Select… button.

  5. Select either a basic or custom color, then select OK.

  6. Fill in the rest of the connection information, and then select the Connect button.

[Top]

To set a server color For a Registered Server

  1. In Registered Servers, right click the server node and then select Properties….

  2. On the Edit Server Registration Properties dialog, select the Connection Properties tab.

  3. Select the Use custom color check box.

  4. To select the color, select the Select… button.

  5. Select either a basic or custom color, then select OK.

  6. Select the Save button on the Edit Server Registration Properties dialog.

[Top]

To open an editor window using a server color

  • Right-click a server node in either Object Explorer or Registered Servers, and select New Query.

  • Alternatively, highlight a server node, and then select the New Query toolbar button.

  • The status bar in the editor window will use the color defined for the associated server.

[Top]

To open an editor window specifying a status color

  • Open the File menu, select New, and then select Database Engine Query.

  • On the Connect to Server dialog, select Options >>.

  • Select the Use custom color check box.

  • To select the color, select the Select… button.

  • Select either a basic or custom color, then select OK.

  • Fill in the rest of the connection information, and then select the Connect button.

[Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft