Looking for AdventureWorks?

AdventureWorks sample database used to be included with SQL Server 2000, but now it's a separate download.

Brian Moran

July 19, 2006

1 Min Read
Looking for AdventureWorks?

Help! I just realized that installing SQL Server 2005 doesn't automatically install Microsoft sample databases, such as AdventureWorks, or related sample applications. How do I install them?

I think installing sample databases is more intuitive in SQL Server 2000 than in SQL Server 2005.You can download these useful tools from the Microsoft Web site at http://www.microsoft.com/downloads/details.aspx?FamilyID=e719e cf7-9f46-4312-af89-6ad8702e4e6e.

For more information about installing sample databases and applications during or after a SQL Server installation, read the SQL Server 2005 Books Online (BOL) topic"Running Setup to Install Adventure-Works Sample Databases and Samples" and my SQL Server Perspectives article "Dig Into AdventureWorks" (May 18, 2006, InstantDoc ID 50388). Personally, I think Microsoft should include the sample database and applications as part of the SQL Server 2005 installation, especially because BOL makes many references to AdventureWorks while explaining features and how functions work. AdventureWorks takes up some disk space, but it's a great learning tool that's valuable for testing new queries.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like