I am working on SQL Server 2005 for quite sometime - PUBS and NORTHWIND database doesn't come along with it by default. But most of my samples which i already have are based on either one of these database. So instead of recreating the sample just for testing purpose I went in search of an answer for "How to create Pubs and Northwind DBs in SQL 2005?".
Here is my findings. We can do it without much trouble. Just go here and download the .msi file and install it.
Instruction for installing:
The SQL Server 2000 sample database scripts are available as an installation file, SQL2000SampleDb.msi. After downloading, extract the sample database scripts by double-clicking on the .msi file. That would extract the database scripts and a readme file into the default folder - "C:\SQL Server 2000 Sample Databases"
Hope this helps!
Technorati tags: Microsoft, SQL, SQL Server 2005, SQL Server Express