SQL Management Studio 2008 R2 Export/Import color settings

I’m reposting a social.msdn.com question that I found…all of the developers that I work with are changing their colors in VS 2010 and (trying to) in Management Studio, going with the old mainframe-ish black background and mostly yellow or white fonts. Pretty cool these app-devs are. So one of my colleagues asked me about saving changes in SSMS, and I told him that I don’t dork much with the colors, but a quick search I found a nice post here.  Simply follow what “Scott M” says and you’ll be good to go:

Figured this one out.  Once you set your colors to your liking in S.S.M.S you can back them up via the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\FontAndColors

• Marked As Answer byscott_mMonday, November 15, 2010 7:39 PM
• Edited byscott_mMonday, November 15, 2010 8:23 PMtypo

Find the registry key above, hit export, and this will include all of the registry keys below the folder. Move the file to wherever your destination is, double-click on it, and it will add it to the registry of the new computer. Your new settings will be transferred to the SQL Server Management Studio.

Here’s mine. 

…Mmmmmmmmmmm, no. I’m going back to the old.

Thanks for reading,
Lee

----------------------

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/00552b92-3d47-477e-aafc-fb2480519fb3