The Features of SQL Server 2000

SQL Server 2000 combines functionality that was available in previous versions of SQL Server and new functionality added only in this version. The older functionality is what made SQL Server popular to start with and the new functionality enables you to do things that were impossible in previous versions.

The Old Staple Functionality

The old staple functionality is what originally made SQL Server popular in the marketplace. Much of this popularity has to do with the ease of use and administration inherent in SQL Server as well as the ease of available application development and power. Some of the staple functionality is as follows:

  • Graphical Management Tools— These tools, such as SQL Enterprise Manager, make it ...

Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.