Here you can find all sample databases:
Visit the SQL Server Samples and Community Projects page on CodePlex at:
http://codeplex.com/SqlServerSamples
For those people who looking something specific as follow the same link above, you can see the original names of databases below. And also you can see step by step manual how to install and attach database to your SQL server.
AdventureWorks - AdventureWorksDB.msi
AdventureWorksDW - AdventureWorksBI.msi
Northwind and pubs Sample Databases for SQL Server 2000 Download
(by default after installation completed you can find northwind database, under this location
C:\SQL Server 2000 Sample Databases\. For installation in more detail click here)
First Step. Download the file you need. Install (by default it will install it C:\Program Files\Microsoft SQL server\MSSQL.1\MSSQL\Data\nameofdatabase.mdf)
Next Step. Open SQL server, right click on Databases (on your left). Select Attach then press add button. Select database that you need and press OK.
