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 the NorthWind Database required ZIP msi file from Microsoft website.
Step 2 :
After successfully installing the NorthWind database msi file, your files will be located in folder :
“C:\SQL Server 2000 Sample Databases”
Please check it.
Step 3 :
Open your SQL Management Studio and select Attach Database option from the menu of the connected server.
Attach Option will Pop-Up. In the Window select the .mdf file of your NorthWind databases files from the folders :
C:\SQL Server 2000 Sample Databases
And Click Ok.
NorthWind Database will be attached and restored on your SQL Server. Expand the Databases node on your SQL Management Studio Server node :