November 3, 2004 at 12:34 pm
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
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply