Hi, We are Currently using SQL Server 2008.
We have SQL Server 2000 (80) Compatibility----6 Databases
We have SQL Server 2005 (90) Compatibility----5 Databases
We are planning to use SQL 2008 Features.
1)So Can we directly Change SQL Server 2000 (80) to SQL Server 2008 (100)?
2)After Make change Is Any Query to check Functions or SPs working correctly or not?
Yes you can make that change. However, I'd strongly suggest that you use the Upgrade Advisor as @Squirrel mentions as well as perform any type of regression tests that you might have available.
I don't know of any script/tool that you can use to definitely say that you have a compatibility issue other than Upgrade Advisor.
You can also check here: http://technet.microsoft.com/en-us/library/bb510680(v=sql.100).aspx to see what the differences are between 80/90/100.
Hope this helps!
answered Jul 27, 2014 at 02:12 PM
link provided script for check issues