Download Microsoft AdventureWorks Database

Usually when we start writing a new program, or just playing with LINQ, we need a database with some information on it like tables, stored procedures and some data to play with.

Microsoft offers a complete database called AdventureWorks just for that cause.

The database contains more then 50 tables, 9 stored procedures and a few views and functions.

For SQL Server 2005, you can download it from here:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

I downloaded the AdventureWorksDB.msi and the run the following query in the SQL 2005:

   1: exec sp_attach_db @dbname=N'AdventureWorks',    2: @filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',    3: @filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'   4: 
 

For SQL Server 2008, you can download it from this page:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=5705