SQL: Install AdventureWorks

This post shows how to use the SSMS GUI to attach a DB.

1) Download Adventurworks from http://www.codeplex.com/Wiki/View.aspx?ProjectName=SqlServerSamples

2) Install the DB. This will only unpack the mdf file.

3) Attach the DB. Then you can see it in SSMS:

You can either use commands like here: http://www.codeplex.com/SqlServerSamples/Wiki/View.aspx?title=SQLServerDatabasesandSamplesOverview&referringTitle=Home

Or you can browse for the mdf file:

RightClick Databases – Choose Attach

Locate Attach

Click Add

Going to Attach

Select .mdf file – OK

Select MDF

Done!

Attached

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: