Northwind

Question

What is the use of Northwind Database., and attach in sql server database.

Tom Mohan · Answer

Story of Northwind While developing SQL Server 2000, the SQL Server team learned that a PM from the Access team had created a Transact-SQL script from their new sample database, a database named Northwind. By using this newly discovered Transact-SQL script, Northwind could be created in SQL Server too. Northwind was a good database for SQL Server – a better fit than Pubs. By also appearing in the Access documentation, it would help show customers how Access and SQL Server could accomplish many of the same tasks. To illustrate new SQL Server features, the team was also free to make additive changes to the database. The summation of that work is the Northwind database script that shipped with SQL Server 2000. By the time SQL Server 2000 released, much of the SQL Server documentation still referenced Pubs. This is why both databases shipped with the product. Already planning the features for SQL-next, the business intelligence (BI) teams were quickly disappointed with the lack of size and complexity in Pubs and Northwind. To showcase the features of Integration Services and Analysis Services, a "real world" sample database would be required. refer : http://blogs.msdn.com/b/writingdata_services/archive/2013/09/09/revisited-the-story-of-pubs-northwind-and-adventureworks.aspx