Difference: SQL 2000/SP3(65) & SQL7/SP3(65) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Difference: SQL 2000/SP3(65) & SQL7/SP3(65)

There’re a lot of difference between SQL 2000/SP3(65) and SQL7/SP3(65), including:
different system table name, different system table’s column name, different system function name, etc. For example, different system table name:
master.dbo.sysxlogins in SQL2000/SP3
master.dbo.SysLogins in SQL7/SP3
SQL 2000 BOL(SP3) doesn’t have the detail list. Does anybody has a detail list?
Refer to this link http://www.sqlmag.com/Articles/Index.cfm?ArticleID=5658] but you can’t specifically get list of tables changed. I have seen list of changes between the version from books online (updated SP3). HTH Satya SKJ