Thursday, January 21, 2016

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

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










No comments:

Post a Comment