Microsoft SQL Server 2000

Email Alerts

Register now to receive news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • FAQ: Creating and altering SQL Server tables

    Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help. 

  • Chapter Download: Essential SQL Server 2000 maintenance

    This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast 

  • Learning Guide: SQL Server basics

    SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big player, more DBAs will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server in... 

  • Quiz: Database Basics

    Directions: - After reading the question, click on the answer that you think is correct. 

  • flat file

    A flat file is a file containing records that have no structured interrelationship. 

  • OLE DB (OLEDB or Object Linking and Embedding Database)

    OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources. 

  • comma-separated values file (CSV)

    In computers, a CSV (comma-separated values) file contains the values in a table as a series of ASCII text lines organized so that each column value is separated by a comma from the next column's value and each row starts a new line. 

  • Fast Guide: SQL Server 2000 commands

    Here are ten commands you need to know! 

  • relational database

    A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. 

  • SQL Server

    SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment... 

  • relational database management system (RDBMS)

    A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. 

  • full-text database

    A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition to text documents, images ... 

  • database management system (DBMS)

    A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database. 

  • See more Definitions on Microsoft SQL Server 2000
About Microsoft SQL Server 2000

SQL Server 2000 is Microsoft's original database management system, replacing SQL Server 7.0 with the release of the Windows 2000 opertaing system. For those who have yet to upgrade to SQL Server 2005 or 2008, this page features resources focused specifically on Microsoft SQL Server 2000. Here you'll find tips, articles and even basic tutorials for database administrators and developers, as well as information on planning a migration away from SQL Server 2000 to a more recent DBMS.