Export (0) Print
Expand All
200 out of 317 rated this helpful - Rate this topic

Downloading Northwind and pubs Sample Databases

The Northwind and pubs sample databases are not installed by default in Microsoft SQL Server. These databases can be downloaded from this Microsoft Web site.

After downloading SQL2000SampleDb.msi, extract the sample database scripts by double-clicking SQL2000SampleDb.msi. SQL2000SampleDb.msi will extract the database scripts and a Readme file into this default folder: C:\SQL Server 2000 Sample Databases. Follow the instructions in the Readme file for running the installation scripts.

NoteNote

The scripts for creating these databases have been updated to remove the guest account to improve security. The pubs installation script has been updated to include all of the data for the database, eliminating the requirement to run separate jobs to add data after creating pubs.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.