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.
Download SQL Server 2008 AdventureWorks database
For installation instructions please refer my previous article here.
Reference : Pinal Dave (http://blog.SQLAuthority.com)
pinaldave
I received the PrepInstance() error that was sited above. The server has full text query on it. Installing on SQL2008.