SQL Server Performance

changing compatibility level of database from 8.0 to 9.0

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Jun 26, 2011.

  1. Trev256b Member

    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
  2. Luis Martin Moderator

    1) If they work in 2000 then will work in 8.0 compatibility.
    2) Yes.
  3. satya Moderator

    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.

Share This Page