How to use AdventureWorks2012 in SQL SERVER Management Studio

Following steps will give us idea how to use AdventureWorks2012 in SQL SERVER Management Studio 2012

Step 1:
Download AdventureWorks2012 database from following link

https://msftdbprodsamples.codeplex.com/releases/view/55330

This will download two files for database AdventureWorks2012 as data file and log file.

Step 2:
Copy these two files to following location
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA


Step 3:
Now open SQL SERVER management studio.
Right click Databases and select Attach..
Add AdventureWorks2012_Data.mdf file.
Refresh database to view AdventureWorks2012 database in SQL SERVER management studio.