How to install northwind database in sql server 2008 express

In the Context Menu click on the Attach option as shown below. MDF file and press OK button. Related Articles. Add Comments. Thank you for the feedback. The comment is now awaiting moderation. You will be notified via email when the author replies to your comment.

Please select a comment to reply. You can add your comment about this article using the form below. Make sure you provide a valid email address else you won't be notified when the author replies to your comment Please note that all comments are moderated and will be deleted if they are Not relavant to the article Spam Advertising campaigns or links to other sites Abusive content.

Fill in the appropriate settings on the Connect to Server window that appears, and then click Connect. Step 3 : Right-click the Databases folder and then click Attach , as shown in Figure 2. Step 4 : In the Attach Databases window, click Add MDF file, and then click OK. The right pane of the Attach Databases window will look as shown in Figure 4.

When you're done, and if you did the proper actions, the right pane of the Attach Databases window should look as displayed in Figure 5. The window displays the progress of the operation and whether it has completed successfully. Step 8 : To check that everything was successful, in the Object Explorer window, click the plus sign to open the Databases folder.

The Northwind and Pubs databases will be displayed, as shown in Figure 6. Feel free to email me with specific questions about this article, and I will be happy to explain.

I also want to invite you to make use of the forums at the bottom of this article. I wish you well and happy programming. In this section, I will keep a running history of the changes and updates I've made to this article:. We will see the common process first and then after see both the method to set up a sample database in detail.

Download the. I have used AdventureWorks DB version of as that is what was questioned from user. If you download version of it can only be installed in version of Above image displays the location where Sample Database is installed. This is very important task otherwise your database will be created with empty tables.