19 out of 59 rated this helpful - Rate this topic

Samples and Sample Databases

Microsoft SQL Server 2005 introduces the Adventure Works Cycles company. This company with its business scenarios, employees, and products is the basis for the following sample databases:

  • AdventureWorks sample OLTP database
  • AdventureWorksDW sample data warehouse
  • AdventureWorksAS sample analysis services database

These databases are used in the code examples in SQL Server Books Online and in the companion application and code samples that can be installed with the product.

ms124501.note(en-US,SQL.90).gifImportant:
The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred.

Topic Description

Adventure Works Cycles Business Scenarios

Describes Adventure Works Cycles, the fictitious company on which the sample databases are based, and the business scenarios used to determine the design of the databases.

AdventureWorks Sample OLTP Database

Describes in detail the AdventureWorks sample OLTP database.

Samples

Describes how to install samples in this release of SQL Server 2005. Demonstrates how to use a number of SQL Server technologies with a variety of programming languages.

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
how to install AdventureWorksDW
Hi, after giving all the detail in msdn..i am unable to install database. I get a Error code 1901, what should i do ? Pls. help me out. ( currently installed sql 2005 management studio express).


Gail Erickson [MSFT] Hi, the best way to get questions answered is to post in the Microsoft Community Forum. The SQL Server Forums are located here: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1. You will likely want to post this to the Samples forum. You should also provide the exact text of the error message you are getting. Just an error code number is not enough to go on.