Skip to main content
Northwind and pubs Sample Databases for SQL Server 2000
Entry Date: Rate:
RSS Description:

Get scripts for creating the Northwind and pubs sample databases for use with SQL Server 2000 and MSDE 2000.

Although these sample databases will work with SQL Server 2005, the AdventureWorks sample database is recommended for use with SQL Server 2005 and SQL Server 2005 Express Edition.


Northwind is a very simple sample database, many people has blame Ms because was a too much simplistic sample, the thing is... for some cases it's fine (books / articles or post samples, educational purpose).

SQL Server 2005 does not ship this sample DB, but you can restore it by downloading the MSI in this link... funny stuff is no straight forward to install, you will have to:

1. Run the MSI.
2. It creates a folder C:\SQL Server 2000 Sample Databases
3. In that folder you will find the MDF file to attach it to your SQL Server. you will find as well the sql script (if you preffer to create the DB just by running an script).