The installation process installs the Northwind and pubs database files (.mdf and. The sample databases were created for SQL Server 2000, but you can use them in later versions of SQL Server.Ĭlick the Download button and save the SQL2000SampleDb.msi file to a local folder on your computer.Īfter the download has finished, double-click the SQL2000SampleDb.msi file to begin the installation process. In a browser, visit the Northwind and pubs Sample Databases for SQL Server 2000 page on the MSDN Web site. Installing the Database To install the Northwind sample database To download a more advanced version of that includes tools, services, and full-text search, see Microsoft SQL Server Express 2008 with Advanced Services on the Microsoft download Web site. A basic edition of is included with Visual Studio 2008 and later versions. Visual Studio 2008 with Service Pack 1 installed, Visual Web Developer 2008 Express Edition with SP1, or a later version of Visual Studio.Ī local instance of SQL Server or SQL Server Express. In order to complete the procedures that are described in this topic, you will need: How to connect to the Northwind database in an ASP.NET Web application in Visual Studio. How to download and install the Northwind sample database package. This topic describes how to perform the following tasks: The information in this topic is provided in order to support existing documentation that references the Northwind database. The Northwind sample database has been superseded by the AdventureWorks database, which includes new and updated features to illustrate SQL Server capabilities.

Northwind and pubs sample database