Introduction

Microsoft Structured Query Language (SQL) Server 2000 is the latest generation of the popular SQL Server product line and the second release since its core reengineering that produced SQL Server 7.0, released in 1999. This latest release of SQL Server adds native Extensible Markup Language (XML) support, enhanced online analytical processing (OLAP), data-mining capabilities, platform support for Windows 2000, integration with Windows 2000 Active Directory, and numerous performance, usability, and programming enhancements. SQL Server 2000 is available in six different editions to meet all levels of application development and delivery:

• SQL Server 2000 Enterprise Edition
• SQL Server 2000 Standard Edition
• SQL Server 2000 Personal Edition
• SQL Server 2000 Developer Edition
• SQL Server Desktop Engine (MSDE)
• SQL Server 2000 for Windows CE Edition

To meet scalability and availability goals, SQL Server 2000 is the first release designed and built to take advantage of Windows 2000 with support for up to 32 processors and 64GB of memory running on Windows 2000 Datacenter Server. Windows 2000 Active Directory integration adds enhanced server and security management features to SQL Server. The latest version of OLAP support, now called Analysis Services, provides numerous wizards for ease of use and the setup of OLAP and new data-mining solutions. One of the more publicized additions to SQL Server is its native support for XML. SQL Server 2000 offers support for storing, using, and updating XML documents an important requirement because XML becomes the language of choice for many business systems and a fundamental architecture component of Microsoft...