Can we directly change Compatibility level from SQL 2000 to SQL 2008 ?
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!