![]() Setting a server color through the Connect to Server window and Registered Servers work independent of each other, even for the same login. ![]() To set a server color for the newly added Registered Server, repeat the steps as before.Īlthough this feature is very useful, it can also be very unreliable. Under the General tab, choose the Server name instance from the drop-down list, and then click the Save button:įrom here, the new server instance is added to the Local Server Groups folder: To register the local server instances, for example if it is no listed, in the Registered Servers window, expand the Database Engine, right-click Local Server Groups, and then select New Server Registration: Moving on to Connection Properties tab, repeat the exact same steps from before to set up custom connection color, and click the Save button to save the registered server settings: Under the General tab, make sure that the Server name is set same as before: This will open the Edit Server Registration Properties window. In the Registered Servers window, expand the Database Engine, expand the Local Server Groups, right-click the server node and then select Properties command: To register multiple servers at once, right-click the Local Server Groups folder, from the context menu select Task, and then select Register Local Servers If the Registered Server list does not have any server instances under the Local Server Groups folder, right-click the already connected server in Object Explorer, and then click the Register option. To set a server color for a Registered Server, open the Registered Servers pane using either keyboard shortcut combination (Ctrl+Alt+G) or select the Registered Servers item in the View menu from SSMS: Go to Object Explorer, expand the Databases folder of the DESKTOP-T720HHD\SQLEXPRESS server, right-click the AdventureWorks2014 database, and select the New Query command:įrom now on, the status bar in the editor window for any new query to the AdventureWorks2014 database under the DESKTOP-T720HHD\SQLEXPRESS server will be set to the color defined for the associated server:Īs mentioned before, another way to associate a status bar color is from Registered Servers. Once the connection color is selected, click the Connect button: Let’s just pick the green in the top row, 3rd from the left, and then click the OK button: The Color picker window will pop-up in which either a basic or custom color can be selected from the grid. Now, when the database for the connection is selected, check the Use custom color check-box, and click the Select button to select the color: If a particular server is not on the list, make sure to select it from the Server name drop-down box, under the Login tab The list of available SQL Servers in the window does not show all available SQL Servers instances. ![]() Under the User Databases folder, select the AdventureWorks2014 database, and click the OK button: ![]() Click the Yes button to continue:Ī new Browse Server for Database window will appear listing all available SQL Server instances and its databases. This will pop-up a window indicating that this action requires connection to the server. Either type/paste the name in the Connect to database field or select it from the drop-down menu by clicking the Browse server option: In this example, let’s set a color for the DESKTOP-T720HHD\SQLEXPRESS server, AdventureWorks2014 database. By default, the Connection Properties tab is selected and this is the one needed to set up custom connection color: This will expand the window and show three tabs: Login, Connection Properties, and Additional Connection Parameters. Open SSMS, and on the Connection to Server window, click the Options button to show advanced options: The colors can be associated with a specific server node in either Object Explorer or Registered Servers. Microsoft introduced a neat feature in SQL Server Management Studio (SSMS) in SQL Server 2008 that helps users quickly determine which connection a tab is currently using by setting custom connection colors in SSMS for different SQL Server nodes.įor database administrators who work on a multiple SQL Servers simultaneously, this feature is a time-saver that allows users to quickly determine which SQL Server are currently used by looking at a color defined for the associated server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |