Install and Attach Northwind Database in SQL Management Studio

Install and Attach Northwind Database in SQL Management Studio final

In this post I will show How we can download, install NorthWind Database in our SQL Management Studio.

Install and Attach Northwind Database in SQL Management Studio steps :

Step 1 :

Download Northwind database MDF file using this link.

You can also get it from Official mircosoft website.

If you directly want the script file or BAK file,

  1. download Northwind database script.
  2. Northwind database BAK file

 

Step 2 : 

Open your SQL Management Studio and select Attach Database option from the menu of the connected server.

Install and Attach Northwind Database in SQL Management Studio sql attach

Attach Option will Pop-Up. In the Window select the .mdf file of your NorthWind databases files from the folders (Select the location at which you downloaded the MDF file for Northwind database):

C:\SQL Server 2000 Sample Databases

Install and Attach Northwind Database in SQL Management Studio sql select

And Click Ok.

Install and Attach Northwind Database in SQL Management Studio sql selected

NorthWind Database will be attached and restored on your SQL Server. Expand the Databases node on your SQL Management Studio Server node :

Install and Attach Northwind Database in SQL Management Studio final


  1. Base64Encode.io - Realtime Encode your string to Base64 format.
  2. Base64Decode.io - Realtime Decode Base64 data to plain text.
  3. Md5Hash.io - Realtime Encoding in Md5Hash.

5 thoughts on “Install and Attach Northwind Database in SQL Management Studio”

  1. Pingback: DataView Row Count after Filtering Data in C# ASP.NET • ParallelCodes();

  2. Pingback: SQL Server - SELECT DISTINCT Statement - SQL Studio

  3. Pingback: SQL Server - Using GROUP BY - SQL Studio

  4. Pingback: SQL Server – Using GROUP BY - ParallelCodes

  5. Pingback: SQL Server – SELECT DISTINCT Statement - ParallelCodes

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.