Adding the Northwind database to your application

To download the latest version of the instnwnd.sql installer script

1. Go to the Microsoft SQL download website: https://www.microsoft.com/sql/downloads/.
2. Locate the latest version of the Northwind database installer script (SQL2000SampleDb.msi).
3. Download and run the SQL2000SampleDb.msi installer. That creates a copy of the instnwnd.sql installer script on your local hard drive in the following file directory:

   C:\Program Files\Microsoft SQL Server 2000 Sample Database Scripts\

You now have a copy of the instnwnd.sql installer script. Proceed to the next step procedure for installation instructions.

To install the Northwind database in MSDE

1. Go to the command prompt.
2. Locate the Northwind installer script named instnwnd.sql (see table).
3. From the command prompt, change directory to the path of the installer script.

   Type the following command to install the database.

   osql -U sa -P [password] -i instnwnd.sql

4. Press ENTER.

   The Northwind database installs.

   Note   The install process may take several minutes.

--MSDN