SQL Server Management Studio Settings

Miscellaneous, useful settings in SSMS.

Note: This was tested in SSMS 2012.

Assign custom colors to database servers. These colors are used on the status bar.

1. Connect to Server
2. Options >>
3. Connection Properties tab
4. Use custom color:

Change what is displayed in Tab Text (Example: Remove text that is redundant with status bar.)

1. Tools/Options/Text Editor/Editor Tab and Status Bar/Tab Text
2. Include database name (False)
3. Include file name (True)
4. Include login name (False)
5. Include server name (False)

Copy column headers with query results

1. Tools/Options/Query Results/SQL Server/Results to Grid
2. Check "Include column headers when copying or saving the results"