Where to download this version of adventureworks database

sql-server-2008 adventureworks
Tarek Saied picture Tarek Saied · Apr 19, 2012 · Viewed 10k times · Source

Hi all, I started studying SQL Server from this book SQL Server 2008 Transact-SQL Recipes.

My problem is I can't get this file AdventureWorks2008.msi.

A majority of the examples in this book use the AdventureWorks database (SQL Server 2008 OLTP version), which can be downloaded online from the CodePlex site (www.codeplex.com), under the “Microsoft SQL Server Product Samples: Database” project. Look for the file named AdventureWorks2008.msi

When I searched I get this.

Answer

AdaTheDev picture AdaTheDev · Apr 19, 2012

The SQL 2008 AdventureWorks download is available here - it's an exe, give that a try :)

Related questions

Where to download AdventureWorks2008.msi?

I'd like to install AdventureWorks2008 (I just install SQL Server 2008 R2 Express). Each time I download the recommended version from CodePlex, all I get is a AdventureWorks2008.mdf file. Not only I cannot attach the file from SQL Server Management …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More