Northwind
What is the use of Northwind Database., and attach in sql server database.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Tom MohanPosted Apr 11, 2015, 10:59 AM
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