Note: Download SQL Server 2008 AdventureWorks database by Microsoft
The following sample databases are currently available for Microsoft SQL Server 2005 and Microsoft SQL Server 2008:
- The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
- The Adventure Works DW database demonstrates how to build a data warehouse.
- The Adventure Works AS project can be used to build an AS database for business intelligence scenarios.
- The Adventure Works LT database is a highly simplified and smaller sample database which is helpful for those who are new to relational database technology.
For installation instructions please refer my previous article here.
Abstract courtesy : Microsoft
Reference : Pinal Dave (http://blog.SQLAuthority.com)