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.



58 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
    Replies
    1. Yoursomacod.com is the best usa based online pharmacy, get all Brand and Generic medicines without prescription with cash on delivery Service in the USA, at a discounted price.

      we helps you to provide information about prescription drugs that are prescribed to treat various kinds of diseases. We deliver our services in the United States, USA. To place your order as overnight delivery, you can choose your products and place them at any point in time and get it delivered the next day at your doorstep.

      Here are some medicine Yoursomacod.com provide with online prescription, they give information about medicine you want to buy. Visit their website for details

      Get 20% discount with cash on delivery in USA and Canada.

      Buy Xanax Online

      Buy Oxycodone Online

      Buy Percocet Online

      Buy Soma Online

      Buy Tramadol Online

      Buy Dilaudid Online

      Buy Fioricet Online

      Buy Oxycontin Online

      Buy Roxicodone Online

      Buy Klonopin Online

      Delete
  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. Information well shares with to the point words and provides amazing and interesting topics. varsity leather jackets
    harley Davidson men leather jacket
    MotoGP Motorcycle Leather Jackets

    ReplyDelete

  5. We have online store for leather jackets. Buy online real
    Leather Vest with cheap rates & worldwide free shipping.

    ReplyDelete
  6. I am looking for the informative post thanks for share it.
    I have an online store for leather garments with the name of Jackets In Leather.

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

    ReplyDelete
  8. Thanks for share this helpful post. We have an online store of leather jackets. We are offering worldwide free shipping on every order.
    BLACK LEATHER JACKET
    FLYING JACKETS
    LEATHER BOMBER JACKET
    SHEARLING JACKETS

    ReplyDelete
  9. 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
  10. Thanks for sharing this.,
    Leanpitch provides online training in A-CSPO during this lockdown period everyone can use it wisely.
    Join Leanpitch 2 Days A-CSPO Certification Workshop in different cities.

    a-cspo certification
    a-cspo training

    ReplyDelete
  11. I am looking for this informative post thanks for share it. We have an online store of liposuction Instruments. We are offering worldwide free shipping on every order.
    General Suction Cannulas
    Cannulas & Injectors
    Cell Friendly Injectors
    Harvesting Cannulas
    Specialty Cannulas

    ReplyDelete
  12. B3 Bomber Jacket For Sale - Free Shipping and Best Deal
    Men consistently partial to skins and hides due to the fact the start of timethey utilized it to insure by themselves and safeguard them by your cold temperatures.
    Now shearling coats, Real Leather Bomber Jackets, Buy Harley Davidson Leather Motorcycle Jackets holds probably the best legacy , masculinity along with ruggedness to get a guys outer wear.

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

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

    ReplyDelete
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  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. disability news stories

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

    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. disability insurance broker

    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. alcohol treatment centers in Florida

    ReplyDelete
  24. 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
  25. 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
  26. your content is really great and to the point provides good information related to the topic.
    Shalom Lamm

    ReplyDelete
  27. 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
  28. 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
  29. 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
  30. 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
  31. We will try to hold our overview up to date with brands that do accept players.
    Shalom Lamm

    ReplyDelete
  32. 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
  33. 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
  34. If you want to get medicines without going anywhere then you must try
    Pharmacy Oder Online packaging and shipping service

    ReplyDelete
  35. 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
  36. 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
  37. The article was up to the point and described the information about education and learning. Thanks to blog author for wonderful and informative post. Working Capital

    ReplyDelete
  38. 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

Search This Blog