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.