SQL Server 2000

SQL Server 2000

SQL Server 2000 was released in 2000. It is SQL Server Version 8, and it's codename was "Shiloh". The 64-bit edition of SQL Server 2000 was released in 2003 and was codenamed "Liberty".

Features

Microsoft® SQL Server™ 2000 features include:

  • Internet Integration.

    The SQL Server 2000 database engine includes integrated XML support. It also has the scalability, availability, and security features required to operate as the data storage component of the largest Web sites. The SQL Server 2000 programming model is integrated with the Windows DNA architecture for developing Web applications, and SQL Server 2000 supports features such as English Query and the Microsoft Search Service to incorporate user-friendly queries and powerful search capabilities in Web applications.

  • Scalability and Availability.

    The same database engine can be used across platforms ranging from laptop computers running Microsoft Windows® 98 through large, multiprocessor servers running Microsoft Windows 2000 Data Center Edition. SQL Server 2000 Enterprise Edition supports features such as federated servers, indexed views, and large memory support that allow it to scale to the performance levels required by the largest Web sites.

  • Enterprise-Level Database Features.

    The SQL Server 2000 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. SQL Server 2000 distributed queries allow you to reference data from multiple sources as if it were a part of a SQL Server 2000 database, while at the same time, the distributed transaction support protects the integrity of any updates of the distributed data. Replication allows you to also maintain multiple copies of data, while ensuring that the separate copies remain synchronized. You can replicate a set of data to multiple, mobile, disconnected users, have them work autonomously, and then merge their modifications back to the publisher.

  • Ease of installation, deployment, and use.

    SQL Server 2000 includes a set of administrative and development tools that improve upon the process of installing, deploying, managing, and using SQL Server across several sites. SQL Server 2000 also supports a standards-based programming model integrated with the Windows DNA, making the use of SQL Server databases and data warehouses a seamless part of building powerful and scalable systems. These features allow you to rapidly deliver SQL Server applications that customers can implement with a minimum of installation and administrative overhead.

  • Data warehousing.

    SQL Server 2000 includes tools for extracting and analyzing summary data for online analytical processing. SQL Server also includes tools for visually designing databases and analyzing data using English-based questions.

Other Versions of SQL Server

SQL Server Versions

What Version of SQL Server to Use on the Backend

SQL Server 2012

SQL Server 2008 R2

SQL Server 2008

SQL Server 2005

SQL Server 2000 (this article)

SQL Server 7.0

SQL Server 6.5

 
 

Leave a Comment
  • Please add 3 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 10. Comment: Removed "(en-US)" from the title. Adding tags.

  • Ed Price - MSFT edited Revision 5. Comment: Added links to other versions

  • Ed Price - MSFT edited Revision 3. Comment: Adding initial content

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price - MSFT edited Revision 3. Comment: Adding initial content

  • Ed Price - MSFT edited Revision 5. Comment: Added links to other versions

  • Ed Price - MSFT edited Revision 10. Comment: Removed "(en-US)" from the title. Adding tags.

Page 1 of 1 (3 items)