Updated Samples for SQL Server 2000 Service Pack 3

Download the updated samples for Microsoft SQL Server 2000.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:



    Date Published:


    File Size:

    14.2 MB

    6.9 MB

      The SQL Server 2000 Samples (Updated - SP3) download includes updated versions of the samples that shipped with SQL Server 2000, plus new how-to samples for OLE DB and ODBC.

      The Microsoft Analysis Services Samples (Updated - SP3) download includes updated versions of the samples that shipped with Analysis Service in SQL Server 2000, plus a new connection pooling sample.

      The updated samples are available for download as cabinet (.cab) files . These files contain multiple files that have been compressed into one extractable file. You can extract the compressed files by using an expansion utility such as Expand.exe, which is installed with Microsoft Windows®.
  • Supported Operating System

    Windows 2000

      • Microsoft SQL Server 2000 SP3
      • We strongly recommend that all operating systems have the latest service packs and other updates installed to ensure that the software will install and run correctly. Go to the Windows Update site to check for recommended updates.
      • The updated samples are installed by executables (.exe files), which in turn run Windows Installer packages (.msi files). You must have Windows Installer 2.0 on your computer to install the updated samples. If you do not have Windows Installer on your computer, version 2.0 will be installed for you when you run the Windows Installer package. If you have a previous version of Windows Installer on your machine, it will be updated to version 2.0. In both cases you will be prompted to reboot your computer. You must run the Windows Installer package
        again after your computer restarts to complete installation of the updated samples.
      • You must be a member of the Administrators group on the computer where you are installing the updated samples.
      1. Select the appropriate .cab link to start the download.
      2. When prompted, select Save this program to disk, and then click OK.
      3. Select a destination folder for the .cab file, and then click OK to begin downloading.
      4. After you download the .cab file, you must expand it and then run the installation program to install the updated SQL Server or Analysis Services samples.

      Note: The process for expanding a .cab file depends on the Windows operating system that you are running.

      To install on Windows XP, Windows 2000, or Windows Millennium Edition (Windows Me):
      1. In Windows Explorer, double-click the .cab file to display the list of files that it contains.
      2. On the Edit menu, click Select All.
      3. Right-click any one of the selected files, and then click Extract.
      4. In the Browse for Folder dialog box, select a folder for the extracted files, and then click Extract.
      5. After the files have been extracted, double-click Setup.exe.

      To install on Microsoft Windows NT® 4.0, Windows 98, or Windows 95:
      1. On the Start menu, click Run.
      2. In the Run dialog box, type the following command, and then click OK: expand -r cabfilename <path to target folder>. For example, to expand the updated SQL Server samples files into the SQLSamples folder, type: expand -r sql2000samples.cab c:\sqlsamples.
      3. After the files have been extracted, double-click Setup.exe.

      Please refer to the readme file for further information.
Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: