Installing The Northwind Sample Database From Microsoft
The Northwind sample database is probably the most mention sample database of all time. Most of the tutorials on the web uses the Northwind sample database as an example. However, it's not as straight forward to add the Northwind database to your SQL Server instance as you may have think. The reason is because the Northwind database was initially created for SQL Server 2000. Therefore, most of the newer versions of SQL Server will throw an error when you tried to attach the .mdb file. It is easier to run the SQL script that is provided with the download. In this blog we will go over where to download the Northwind sample database, and how to add to your SQL Server instance using the SQL script. 1. Open your browser and type in the following URL in the address bar https://www.microsoft.com/en-us/download/details.aspx?id=23654 2. Click on the "Download" button 3. Save the SQL2000SampleDb.msi file to a location that you will remember in your ...