I am going to try and upgrade SQL from 2005 to 2008 R2 next week. I have just ran the upgrade adviser and attached the report.
I am no SQL expert and don't know how to interpret this report or how to fix what it suggests.
I am only concerned with the WSS_content, MVGSC, GSEIW databases.
The primary reason I am doing this is because I need to upgrade Great Plains to 2013 from version 10 and it requites SQL 2008 instead of 2005.