Sample Databases for SQL Server 2008

Northwind and pubs Sample Databases for SQL Server 2000

File Name - SQL2000SampleDb.msi = instnwnd.sql + instpubs.sql 

Running the Scripts Using osql

To run the scripts using osql:

1.              Open a command prompt window.

2.              From the command prompt, use the cd command to navigate to the folder containing the SQL Server 2000 Sample Database Scripts:

3.              cd c:\SQL Server 2000 Sample Databases

4.              Run osql specifying either Instpubs.sql or Instnwnd.sql as the input file. Here are some examples:

·                            To install the Northwind database on a default instance on the same computer:

osql -E -i instnwnd.sql

·                            To install the pubs database on a default instance on a different computer:

osql -E -S ComputerName -i instpubs.sql

·                            To install the Northwind database on a named instance:

osql -E -S ComputerName/InstanceName -i instnwnd.sql

Microsoft SQL Server Community Projects & SamplesSQL Server 2008R2 product code samples are available here. Download the AdventureWorks 2008R2 family of sample databases and AdventureWorks 2008R2 sample databases