Several of the key features found in SQL Server 2000 are as follows:
Data Warehousing/Business Intelligence Improvements
Windows 2000 Support
Performance and Scalability Improvements
Query Analyzer Improvements
Transact SQL Enhancements
XML is becoming the standard in which businesses communicate and share information. SQL Server 2000 provides extensive XML support. XML support is easy to setup and access. Once you are up and running with XML, you can store XML inside a table, query the XML data through Transact-SQL statements, and even join XML data to relational data through a SQL statement.
Multi-Instance support enables ...