HowTo: Install the Northwind and Pubs Sample Databases in SQL Server Express - CodeProject.Install and Attach Northwind Database in SQL Management Studio - ParallelCodes

Looking for:

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server Express - CodeProject 

Click here to DOWNLOAD

     

Download northwind database sql server 2008 mdf -

 

Perhaps it may be the case that Microsoft has already posted new documentation on installing databases into SQL Server Management Studio graphically; however, at the time this article was originally posted back in , at the time I had been unable to locate an equivalent article in the Microsoft documentation; hence, I wrote my own, which has evolved into this article.

So, enjoy this article, for what it's worth. It's also lost on me why SQL Server distributions don't come with these databases provided, since they are used so ubiquitously through documentation, websites, and tutorials. There are probably several good reasons for this. However, I am focused on usability, and not on making things harder than they have to be.

I see this article as illustrating just another way to accomplish a similar objective. It's worth noting, for example, that a default Visual Studio.

NET Professional Edition installation does not distribute these databases. Unlike the previous version of Visual Studio. NET, it does not even go part-way by installing the required SQL Scripts at least, I have not been able to locate them with the latest version. The download attached to this article contains the latest version of the Northwind and Pubs database files as distributed by Microsoft on MSDN.

Personally, I favor using graphical GUI tools and methods over typing cryptic commands and deciphering error messages. So, this article illustrates how to install the Northwind and Pubs databases using graphical tools and methods. Step 1 : Using the download link above, download the Zip file containing the following files. Extract the files to a directory on your computer and remember where you put them. For these steps to work, you must have the following files on your computer:.

Note : Make sure that you have read-write access to these files, and that they are in an easily-accessible directory. 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.

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp. Give your Valuable Comments. Please enable JavaScript! Bitte aktiviere JavaScript!

Por favor,activa el JavaScript! Home Asp. Introduction : Here I will explain how to download and install northwind and pubs sample database in sql server or attach northwind database in sql server r2 using sql server management studio. Description :. In previous articles I explained replace multiple spaces with single space in sql , reseed identity column value in sql server , get time difference between two dates in sql , substring function in SQL server and many articles relating to SQL server.

Now I will explain how to install northwind sample database in sql server To install northwind and pubs sample databases in sql server you need to follow below steps.

Once we click Attach it will open Attach Database window in that click Add like as shown below.