Differences between MSSQS 6.5 and 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Differences between MSSQS 6.5 and 2000

Hi ALL, Can some one please tell the differences between MSSQS Server 6.5 and MSSQS Server 2000 , Is there any document to refer so please advise me . Thanks and regards

There are probably more detailed one’s out there, but this one is concerned with issues happening during the upgrade process:http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

The difference between SQL 6.5 and SQL 7.0 was much bigger than the difference between SQL 7.0 and SQL 2000. You should be able to find promotional material for SQL 7.0 that compares 6.5 and 7.0, and for SQL 2000 that compares 7.0 and 2000.
Hi, I want general technical differences Regards,

If you want a whole list of differences then on SQL 2000 books online under Search tab type ‘6.5’ for complete information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
without checking any documentation, there are three things in my mind<br />a. DB file structure and auto grow (no device any more. also impact on backup/restore)<br />b. row level locking<br />c. XML <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />