I am currently leading the charge to upgrade our SQL Server 2000 databases up to SQL Server 2008. Since I work on the application side, I am only interested in what items need to change or be upgraded in terms of objects (stored procs, views, tables, etc...).
I tried using the Upgrade Advisor, which proved pretty useless. I was wondering if anyone had a list of items that worked in SQL Server 2000, but stopped working in SQL Server 2008 (either generated an error when running or no longer returned desired results)?
For example, I know TOP 100 PERCENT..ORDER BY no longer works correctly in views...
Any help would be very appreciated!
Thanks,
Michael