What is major different between SQL2000 and SQL 7.0.

-- Anonymous, October 18, 2003

Answers

Tong Liang,

You will find a good summary at http://www.microsoft.com/sql/evaluation/overview/whatsnew.asp.

Here is a list of the major differences: What's New in Microsoft SQL Server 2000

Relational Database Enhancements XML Integration of Relational Data Graphical Administration Enhancements Replication Enhancements Data Transformation Services Enhancements Analysis Services Enhancements Meta Data Services Enhancements English Query Enhancements Documentation Enhancements What's New in Analysis Services

Cube Enhancements Dimension Enhancements Data Mining Enhancements Security Enhancements Client Connectivity Enhancements in PivotTable® Service Other Enhancements What's New in Meta Data Services

Meta Data Browser Enhancement XML Encoding Enhancements Repository Engine Programming Enhancements Repository Engine Modeling Enhancements

Hope this helps,

Eric

-- Anonymous, October 19, 2003