This is a really useful resource from where you can download over 100 samples and three sample databases for SQL Server 2005.

The downloads demonstrate the following components:

  • Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML
  • Analysis Services
  • Integration Services
  • Notification Services
  • Reporting Services
  • Replication