That of course, would not cover anything that is outside of the SQL world, such as ad-hoc queries some programmer may have incorporated into his/her code. For such things, you should look up the discontinued features list here: http://technet.microsoft.com/en-us/library/ms144262.aspx

Microsoft has a lot of resources to help you upgrade. Wander around through MSDN.