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.0

if 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.
2) Yes.
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |