If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.

However, SQL Server Compact Edition uses Northwind as a sample database. MSDN Book On Line (BOL) uses the AdventureWorks in all of their examples and it makes it easy to follow up if a proper understanding of AdventureWorks schema is developed. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005.

Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind database was the best sample database for SQL Server 2000. Let us learn how to install NorthWind Database – samples databases.Īfter installing sample databases the second most asked question is WHERE IS NORTHWIND?

AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005.