SQL administrators that works on several SQL Servers at the same time may have to open several SSMS windows to quickly switch from one server to another. But sometimes having too many windows on your screen can be confusing. Luckily for us, there are ways to make sure you are running the a query on the right server. One method is to check which SQL server you are currently logged-in and another is to color code your SQL Server Management Studio query editor.

To change the status bar of a SQL Server 2008's SSMS query editor, follow these steps:

1. On SSMS Connect to Server dialog, click Options button.



2. Then select the Connection Properties tab.
3. Tick the "Use Custom Color" checkbox and click the Select button beside it to choose the custom color as shown below.




4. Now create a new query. The status bar color should already changed.



For more SQL Server Tips, subscribe now.

Labels: Microsoft SQL Server