Tech Junkie Blog - Real World Tutorials, Happy Coding!: Install the Northwind Sample Database

Sunday, June 19, 2016

Install the Northwind Sample Database

If you look on the web you will eventually find an example that refers to the Northwind sample database in one of the their examples.  What they fell to tell you is where to find this sample database and how to add to your database.

Follow these steps to add the Northwind sample database to your SQL Server:

1. Go the URL http://www.microsoft.com/en-us/download/details.aspx?id=23654 and download the Northwind and pubs sample database from Microsoft.



Microsoft Sample Northwind Database Download Button


2. Double click on the SQL2000SampleDb.msi file, then click "Run"


SQL2000SampleDb.msi Executable File


3. After you finished with the installer you will have the sample databases in the "SQL Server 2000 Sample Databases" folder in the C drive

4. Log onto SQL Server using SQL Server Management Studio

5. Right-click on the "Databases" node inside the "Object Explorer" window, then select "Attach"
Attache Northwind database

6. Click on the "Add" button, in the "Attach Database" window

SQL Server Attach Databases Wizard


7. Select the "NORTHWND.MDF" file inside the "SQL Server 2000 Sample Databases" folder
Select Northwind.MDF file


8. Click "OK"


Attach Northwind database

9. SQL Server will automatically create a log file for the .mdf file you just attached


Northwind database log file

10. Click "OK"

11. Northwind database is added to SQL Server

Northwind database attached

Note: You can perform the steps above for the pubs sample database, the only thing you have to watch out for is that some sample databases might not be compatible with your version of SQL Server.  In that case you will have to run the .sql script instead if you want to use the database.  There might be some trial and error involve if you have to run the sql script but it shouldn't be too bad.



57 comments:

  1. When my Bellsouth Mail Not Opening is contact technical professionals over toll free helpline number and get most suitable solutions. These experts are well knowledgeable to solve issue in meanwhile time. Whenever you face any issue, you can also contact them over Bellsouth Customer Service 1(888)404-9844. These all are really polite & soft spoken.


    ReplyDelete
  2. Face issues like Outlook Not Opening/Responding/Loading/Working then don not wastes your time just connect to the experts. These all experts are well qualified to solve issues. Just connect to them over Outlook Customer Service 1(888)404-9844 and take their help.


    ReplyDelete
  3. Users want to Read more Technology News in Tamil kindly visit Thudhu. Here You can learn latest Tech News, Gadget News and Mobile application news and comment submission too allowed

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Thankful to you, I should say to it's palatable post for blog. McDVOICE Survey

    ReplyDelete
  6. Amazing Article. Thankful to you, amazingly obliging.. does coconut flour expire

    ReplyDelete
  7. This is Microsoft's big success and many users are happy because they can enjoy your services for free and solve their issues easily. I hope, you will share products more in future. Dissertation writing services.

    ReplyDelete
  8. Thanks for ones marvelous posting! I really enjoyed reading it, you might be a great author.
    I will be sure to bookmark your blog and will eventually come back later on.
    Just visit our webpage on visiting card size

    ReplyDelete
  9. When you add private label products to your existing line of products, it can be beneficial for your business in many ways. Airbrush tanning near me

    ReplyDelete
  10. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. customer service call center

    ReplyDelete
  11. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. disability news stories

    ReplyDelete
  12. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. boaz derra

    ReplyDelete
  13. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. disability insurance broker

    ReplyDelete
  14. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. alcohol treatment centers in Florida

    ReplyDelete
  15. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. BTC near me

    ReplyDelete
  16. Shiba Inu Puppies For Sale Australia – Shiba Inu Breeder

    8 hours ago One high-spirited dog that we have is the Shiba Inu. Nobody can resist the cuteness of this amazing dog breed. If you are searching for Shiba Inu puppies for sale in Australia, then Dean & Ivy Companion Farm is the hub. Please contact us. We assure you that we will give you the puppies at the best Shiba Inu puppy price in Australia. http://www.deannivycompanionfarm.com

    ReplyDelete
  17. Great post. I was checking constantly this blog and I'm

    impressed! Extremely helpful info specially the last part :

    ) I care for such information much. I was seeking this certain info for

    a very long time. Thank you and good luck.
    Shalom Lamm

    ReplyDelete
  18. Great weblog here! Additionally your web site loads up fast!
    hyperlink for your host? I want my web site loaded up as fast as yours lol.
    Shalom Lamm

    ReplyDelete
  19. Thank you for the good writeup. It in fact was a amusement account it.

    Look advanced to far added agreeable from you! By the way, how could we communicate?
    Shalom Lamm

    ReplyDelete
  20. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. AA Meeting Directory

    ReplyDelete
  21. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. sober living homes

    ReplyDelete
  22. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post.

    ReplyDelete
  23. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. wholesale cbd shops

    ReplyDelete
  24. Thanks for sharing a great article. However, if you are looking to know more about Systematic Literature Review, its detailed process, and how it is useful in many research works. Read the article Systematic Literature Review - A Detailed Process
    Also check Vital Strategies to Follow for Systematic Research Work
    Understanding What A Clinical Evaluation Report Is
    A Comprehensive Guide to Requirements of PMCF of EU MDR

    ReplyDelete
  25. excellent work
    https://keyposting.com/simplest-ecommerce-website-builder-richart-ruddie-annuity/

    ReplyDelete
  26. keep going like this
    https://www.dorjblog.com/richart-ruddie-annuity-describes-telemarketings-pros-and-cons/

    ReplyDelete
  27. i like your work
    https://postpear.com/e-commerce-web-site-builder-by-richart-ruddie-annuity/

    ReplyDelete
  28. good job you smartly doing your work
    https://vocal.media/01/richart-ruddie-annuity-views-on-importance-of-digital-marketing

    ReplyDelete
  29. your work is enjoyable and after reading your article i feel myself energetic
    https://theblogulator.com/richart-ruddie-annuity-reviews-on-a-telemarketing-agency/

    ReplyDelete
  30. i really enjoyed your work
    https://sketchfab.com/Richart.Ruddie.Annuity

    ReplyDelete
  31. smart work man
    https://www.law.com/legalnewswire/news.php?id=2862814

    ReplyDelete
  32. fablouse work
    https://keyposting.com/simplest-ecommerce-website-builder-richart-ruddie-annuity/

    ReplyDelete
  33. It's helped me because I want to start with a clean slate and it's helped the kids because it's made them also start with a clean slate," Hansen said.
    Across the valley, new Mountain View coach Teko Johnson was handling his job in a similar fashion. He didn't watch any 2006 game film to see what the Bruins did last year and he didn't want to know. He also didn't care who played what position. Basically, he wanted to know nothing from the past and he wanted the players to know he wasn't interested in the past
    Technical Recruitment

    ReplyDelete
  34. Richart Ruddie Annuity said one of the hottest sectors in the new millennium is international trade. It is, however, not a novel concept. Consider the biblical era’s huge caravans with their cargoes of silks and spices. Consider prehistoric man’s trading of shells and salt with faraway tribes. Because one group or country has a supply of a commodity or goods in demand by another, trade exists. And as the globe grows more technologically sophisticated, as we shift toward one-world patterns of thought in subtle and not-so-subtle ways, international trade becomes more and more gratifying, both in terms of profit and personal fulfillment. Importing isn’t only for lone adventurers who live by their wits and the skin of their teeth
    digital marketing

    ReplyDelete

  35. According to Richart Ruddie Annuity, it’s a huge business these days, worth $1.2 trillion in commodities annually. Exporting is as important. In only one year, American businesses shipped $772 billion in goods to more than 150 nations. Everything from drinks to commodes along with a long list of other items you’d never think of as global merchandise is fair game for the astute trader. Daily, these items are bought, sold, represented, and dispersed somewhere in the world.
    digital marketing

    ReplyDelete
  36. Acts 1:8 Ministry has helped build over 130 water wells and towers in Africa, blessing hundreds of thousands of lives with clean water. As a 100% donor-supported organization, all efforts rely on generous donors who want to help spread kindness, strengthen their faith, grow the Christian church, and enrich communities.
    Leadership, Business

    ReplyDelete
  37. If you are facing Eviction problem in Louisiana, please contact us to resolve this issue. Eviction Baton Rouge


    ReplyDelete
  38. The given info is very helpful for me. For more info please read this article. Best Newborn Diapers

    ReplyDelete
  39. This site has indeed been transformed into my desired as I constantly look for valuable material correct here.
    url opener
    online filmek
    uwatchfree

    ReplyDelete
  40. I will certainly be waiting anxiously for this kind of exemplary details as I delighted in a great deal while reading through your blog post.
    uwatchfree
    Playtubes

    ReplyDelete
  41. Thanks for sharing this valuable information with us.
    Gothic EMO Pants

    ReplyDelete
  42. Urmăriți Pe All Serialele Turcesti 2023 Netflix Online. Urmărește Serialul Românesc Gratis Online Streaming Video HD. You Can Enjoy It TV Shows And Seriale Turcesti Comedii Romantic And Filme De Dragoste Streaming For Free

    ReplyDelete
  43. Urmariti Online Serial Drama, Actiune, Drama, Si Comedie, Seriale Turcesti Vechi sau Nou in situatii foarte odihnitoare. Asta înseamnă că inima ta se simte confortabil seriale turcești comedie romantică, atât de mult încât te simți confortabil. Vă puteți bucura și, de asemenea, să împărtășiți cu prietenii și cu Faimly.

    ReplyDelete

Search This Blog