Recently, I wanted to get some sample databases to play around with in a fresh 2008 install. In order to use the intellisense and other schnazzy features, I got the AdventureWorks DB. The process is less than straightforward, so this write-up may be of assistance:
http://codeslammer.wordpress.com/2008/10/05/sql-server-2008-sample-databases/