Download Database Northwind Sql Server 2008 ((better)) Now

Copy Northwind.mdf and Northwind_log.ldf to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ (adjust for your instance name).

Depending on your download choice, follow these instructions to set it up: Method 1: Using the SQL2000SampleDb.msi By default, this extracts the C:\SQL Server 2000 Sample Databases SQL Server Management Studio (SSMS) Right-click and select Locate and select NORTHWND.MDF to add it to your server instance. Microsoft Learn Method 2: Using the Download the instnwnd.sql Open the script in download database northwind sql server 2008

If you encounter an error about SET ANSI_NULLS or compatibility level, it is safe to ignore or modify the script at the top to include: Copy Northwind

| SQL Server Version | Northwind Build Required | File Type | |-------------------|--------------------------|------------| | 2008 (10.0.x) | RTM / SP1 / SP2 / SP3 | instnwnd.sql (pre-2012 format) | | 2008 R2 (10.50.x) | RTM / SP1 / SP2 / SP3 | instnwnd.sql (compatibility level 100) | The Northwind database is not included with SQL

While originally created for SQL Server 2000, the official Microsoft installer works for SQL Server 2008.

The Northwind database is not included with SQL Server 2008, but it can be downloaded from various sources. Here are a few options: