A few of the more common things that will probably break your SQl 2008 upgrade if you have not run the upgrade advisor for SQL 2005 & corrected them:
Database compatibility < 80
*= & =* joins
SET ROWCOUNT for INSERT, UPDATE, DELETE
Changes that may break SQL 2000 - 2005 upgrade.