Post reply

Difference in Compatibility level 65 and 80

  • November 3, 2004 at 12:34 pm

    #87019

    Hi,

    I have SQL Server 2000 which is upgraded from 6.5. All user databases are set to compatibility level 65. I found the table from books online/sp_dbcmptlevel which shows how some behaviours will change, but nothing shows what will be benefit if i change compatibility level from 65 to 80.  What functionality of SQL Server I am missing while I have the database in 65 compatibility level. The only information I found is following from microsoft site.

    While running at compatibility level 60 or 65 preserves legacy behaviors on SQL Server 2000, support for these behaviors may be dropped in future versions of SQL Server. It is recommended that you plan to upgrade your applications to work correctly with the compatibility level set to 80 as soon as is practicable.

    Is that the only reason for me to change compatibility level from 65 to 80? Is there microsoft document about which functionalities will not work in compatibility level 65? All I see on microsoft website is the list of functionality removed.

    Thank you in advance for your reply.

  • November 8, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 8, 2004 at 9:36 am

    #529336

    Since 65 mimics a v6.5 server, some of the keywords that are used for advanced functionality, like TOP, INSTEAD OF triggers, etc, do not work. If it works for you, then it might not be worth changing.

    The other thing to be concerned with is that the keywords changed in v7 and 2000, so your application might have issues in places with code that uses these keywords.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply