Just a quick FYI on this free tool that can help you verify your SQL DB before upgrading to SQL 2008:
http://www.scalabilityexperts.com/default.asp?action=article&ID=43
I haven’t had an opportunity to try this tool out myself, but it does come recommended from my colleagues on the SQL team.
Thanks,
Jamie