HOW TO INSTALL NORTHWIND DATABASE IN SQL SERVER MANAGEMENT STUDIO 2008

HOW TO INSTALL NORTHWIND DATABASE IN SQL SERVER MANAGEMENT STUDIO 2008




Step1:

Download Northwind and pubs sample database from the below link:

http://www.microsoft.com/en-us/download/details.aspx?id=23654

Step 2: Run and Install this downloaded application.

Step 3: Now Northwind and pubs databases will be shown like below :-

Step 4: Now open SQL Server Management Studio: 

Step 5: Go to File -> open -> file...  in SQL Server Management Studio.

Step 6: Now open the file 'instnwnd.sql' present in the folder --->     "C:\SQL Server 2000 Sample Databases". 

Step 7: Now execute this file.

Step 8: Now run another query ->  

use Northwind

Step 9: It is done. Now you can see in the list of databases, Northwind is listed there.

Below Links are also useful for installation of Northwind database :

https://www.youtube.com/watch?v=bICR28X2sUE

https://www.youtube.com/watch?v=auf1bjrAGCU

--------------------------------------------------------------------------------------------------------------------------