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.



68 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. We have online store for leather jackets. Buy online real
    Leather Vest with cheap rates & worldwide free shipping.

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

    ReplyDelete
  6. Interesting post it is very helpful thanks for share it. We have an online store of leather jackets & Puffer jackets. we are offering worldwide free shipping.
    HARLEY DAVIDSON JACKETS

    MOTORCYCLE LEATHER JACKET

    PUFFER JACKET

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

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

    ReplyDelete
  9. Totally loved your article. Looking forward to see more more from you. Meanwhile feel free to surf through my website while i give your blog a read.
    Curtains in dubai
    Carpets in dubai
    Blinds In Dubai

    ReplyDelete
  10. 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
  11. 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
  12. 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
  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. customer service call center

    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. disability news stories

    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. boaz derra

    ReplyDelete
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. I really like the knowledge you provide here and can't wait to take a look when I get home.

    I'm shocked at how quick your blog loaded on my mobile .. I'm not even using WIFI, just 3G ..

    Anyways, very good blog!
    Shalom Lamm

    ReplyDelete
  23. I have been surfing online more than 4 hours today, yet I never found any

    interesting article like yours. It's pretty worth enough for me.

    Personally, if all site owners and bloggers made good content

    as you did, the net will be much more useful than ever before.

    By the way, here is a link to fantastic site for earnings
    Shalom Lamm

    ReplyDelete
  24. 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
  25. Great blog here! Additionally your web site a lot up very fast!

    What web host are you the usage of? Can I am getting your *****ociate link to your host?

    I wish my site loaded up as quickly as yours lol Shalom Lamm

    ReplyDelete
  26. 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
  27. 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
  28. 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
  29. Very Informative and helpful, Thanks for sharing ... <a href="https://studskit.com">Studs Kit Jacket Shop
    serves with premium quality to leather fanatics.</a> <a href="https://studskit.com/collection/leather-
    collection/mens-leather-jacket/shearling-jackets">Shearling Jackets For Sale</a> <a
    href="https://studskit.com/collection/motogp-collection/motogp-leather-suits"> MotoGP Leather Suits
    For Sale</a> <a href="https://studskit.com/collection/motorcycle-collection/harley-davidson-jacket/
    ">Harley Davidson Jacket For Sale</a>

    ReplyDelete
  30. 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
  31. 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
  32. excellent work
    https://keyposting.com/simplest-ecommerce-website-builder-richart-ruddie-annuity/

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

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

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

    ReplyDelete
  36. 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
  37. i really enjoyed your work
    https://sketchfab.com/Richart.Ruddie.Annuity

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

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

    ReplyDelete
  40. Thanks for sharing your thoughts. I truly appreciate your efforts and I will be waiting for your further write ups thank you once again.
    Genuine High Quality Leather Jackets.
    V Bomber Leather Jackets Men Available to be purchased
    Harley Davidson Leather Jacket Men Clothing Available to be purchased
    Mens B3 Bomber Leather Jacket Available to be purchased
    RFX Leather

    ReplyDelete
  41. 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
  42. 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

  43. 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
  44. 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
  45. If you are facing Eviction problem in Louisiana, please contact us to resolve this issue. Eviction Baton Rouge


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

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

    ReplyDelete
  48. 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
  49. Thanks for sharing this valuable information with us.
    Gothic EMO Pants

    ReplyDelete

Search This Blog