Where is the Northwind SQL scripts for SQL server 2005

Where is the Northwind SQL scripts for SQL server 2005

• Juergen Pfeifer

  No, we did not update the Northwind or pubs sample databases for SQL Server 2005. Instead, we created a new sample database called AdventureWorks that ships with SQL Server 2005. See Books Online for more information about this new sample database.

  Regards,

  Gail

  
  
  

• GodzillaMonster

  Hi Mary,

  Unfortunately, the error message you're getting is misleading in this case. You need to change the database compatibility level of the Northwind (or Pubs) database must be changed to 90. You do this by running the following statement:

  EXEC sp_dbcmptlevel 'Northwind','90'

  Alternatively, you can set the compatibility level through SQL Server Management Studio by right-clicking on the Northwind database and selecting Properties. From the Properties page, you can select the 90 compatibility level.

  Once you've changed the level, try the database diagram tool again.

  Regards,

  Gail

  
  
  

• NewSQL2005 User

  Hello,
  Northwind does not ship with SQL Server 2005.  It is available from the Microsoft download site: http://www.microsoft.com/downloads/details.aspx FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en
  
  See the topic Downloading Northwind and pubs Sample Databases in SQL Server 2005 Books Online for details.
  
  Regards,
  
  
  

• JP Beaulieu

  Did anyone notice that the link given just points you to the download for the SQL 2000 NW database. Isn't there a different one for SQL 2005
  

• Brian Fitzgerald

  Hey please include this database if all future releases!!! You know how many walk through scritps use this thing for training and learning ! ! !

  Thanks

  
  

• crescens2k

  Suggestions and requests 'should' be logged on the SQL Connect site so that the development team will have accesst to them.

  Suggestions for SQL Server

  http://connect.microsoft.com/sqlserver

  
  
  

• houtexwebdev

  The Orcas Beta 1 C# LINQ samples (specifically the Dynamic Query sample) have code that references the Northwind database. You might want to tell the C# team that Northwind should not be used, or update Northwind. In either case, it's causing confusion.

  
  

• sacrosancttayyar

  Thanks, I do have AdventureWorks and will use it, I'm sure. I just have a lot of current material using Northwind as examples that will take me a while to change. So I'd like to have Northwind too. But I did figure it out, as you can see by my next comment!

  Thank you.

  
  

• ujjwalprakash

  Thank you! I wouldn't have guessed that in a million years! It really is a misleading error. Hope that can be fixed. It frustrated me for a couple of hours.

  Your solution worked like a charm though. Thank you, thank you!!

  Mary

  
  

• jim5400

  Thank you very much
  

• comcy

  I went ahead and downloaded the .MSI file for SQL 2000 samples and then attached the MDF files for Northwind and Pubs into SQL 2005. Looks good except I am not allowed to create a database diagram! I get the following error message:

  "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the DB properties dialog box or the Alter Authorization statement to set the DB owner to a valid login, then add the database diagram support objects."

  When I try both methods that are suggested I am unable to get them to work. Can anyone give me the correct Alter Authorization statement so that I can set the DB owner to a valid login

  Help!

  Thanks

  
  

• Questa

  Hi Arnie,

  thanks for sharing the helpful link. i downloaded the northwind db setup from the microsoft site and i found that the script are not complete.

  im not able to find ProductsByCategory and many other like CategoriesList etc stored procedure at all. im surprised that how could microsoft could share the incomplete setup as this DB is being used by lot of technical while writing technical papers and other resources.

  can you do needful as im badly stuck because im not able to test a sample code for last 2 days

  thanks,

  bhavtosh

  
  
  

• Chandru R

  Thanks.
  

• Frens

  Friendly FYI...

  http://www.microsoft.com/downloads/details.aspx FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

  
  
• Where is the Northwind SQL scripts for SQL server 2005