changing compatibility level of database from 8.0 to 9.0 | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
changing compatibility level of database from 8.0 to 9.0if i have attached a 2000 database on a 2005 instance this will still show as compatibility level 8.0.
1) Will all functions of this database still work on 2005 if i leave this as compatibility level 8.0? I’m thinking only some queries will be inefficient. 2) If i change compatibility level to 9.0 then will i need to resolve all of the listed compatibility issues or change in behaviour listed on this site?: http://msdn.microsoft.com/en-us/library/ms178653(v=SQL.90).aspx
1) If they work in 2000 then will work in 8.0 compatibility.
Yes the compatibility between 2005 (90) and 2000 (80) is available, but you should start changing the functions if those are important for the business. You may also review the DEPRECATED and DISCONTINUED features information from SQL Server books online for 2005. Yes you must resovle the issue listed on that link in order to continuing the code to execute in current version.