Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

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 RSS subscribe by email Subscribe by Email

1 comments :

Sushil Gupta said...

what is benifit of northwind db?

Give your Valuable Comments

Other Related Posts

© 2010-2012 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.