SQL Server - How to find environment difference on SSMS Query window

This article is about finding environment difference on SSMS query window .

Suppose If we have access to all environments (Production,QA and Development), we should be really careful in executing DML scripts on respective environments.

On query window at the bottom, we can find the server name, user name, SPID and database details as shown in below image :

We have one more option to find easily environment difference on SSMS query window
by defining colors for each  environment .

Options <<  - > Connection Properties - > Connection - > Use custom color - > Select ...

Note :
This setting applies to particular Server type , Server name , Authentication  type and User .

See Also:

No comments: