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
RAISERROR syntax
More here...
Deprecated Database Engine Features in SQL Server 2008
Changes that may break SQL 2000 - 2005 upgrade.
http://msdn.microsoft.com/en-us/library/bb510680(SQL.100).aspx
No comments:
Post a Comment