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.



18 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. 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

Search This Blog