Tuesday, November 2, 2010

Install northwind and pubs sample database on SQL Server 2008

I’m pretty new to database. This is how I installed northwind and pubs sample database on SQL Server 2008.

1. Download “SQL2000SampleDb.msi” and execute the msi file, which will extract files under “C:\SQL Server 2000 Sample Databases”
2. Run “SQL Server Management Studio” and connect to “Database Engine”
3. Choose File->Open->File and select the “instnwnd.sql” (for northwind database) or “instpubs.sql” (for pubs database) under “C:\SQL Server 2000 Sample Databases” folder.
4. Click “Execute” on the toolbar or “Query->Execute” to execute the sql commands.

No comments:

Post a Comment