Install Northwind Pubs Sample Database SQL Server 2008

Introduction:

Here I will explain how to download and install northwind and pubs sample database in sql server 2008 or attach northwind database in sql server 2008 r2  using sql server management studio.

Description:

In previous articles I explained replace multiple spaces with single space in sql, reseed identity column value in sql server, get time difference between two dates in sql, substring function in SQL server and many articles relating to SQL server. Now I will explain how to install northwind sample database in sql server 2008.

To install northwind and pubs sample databases in sql server 2008 you need to follow below steps

1. First we need to download available SQL2000SampleDb.msi file from this location Northwind and Pubs Sample Database

2. Once we download SQL2000SampleDb.msi file right click on that and install it like as shown below

3. Once we install SQL2000SampleDb.msi file that will create folder here “C:\SQL Server 2000 Sample Databases” with database files like as shown below

4. Now open Microsoft sql server management studio and login in Right click on Databases à Select Attach like as shown below

5. Once we click Attach it will open Attach Database window in that click Add like as shown below

6. Once we click Add button it will open Locate Database files window in that go to c:\SQL Server 2000 sample databases folder and select Northwind.mdf file and click OK button like as shown below

7. In attach databases window also click OK button after that right click on Databases and refresh it you will find Northwind database like as shown below

Same way we can add PUBS database also

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email