Josh Robinson's WebLog

Download Northwind and Pubs from Microsoft for SQL 2005

In case you need to run a sample that relies on Northwind or Pubs yet you are using SQL 2005, you can download those classic sample databases directly from Microsoft here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

Comments

Varad said:

Thanks a lot for this information!
# March 26, 2006 3:29 PM

manu said:

yeeeaaaaa.

this is my database!!!

# December 12, 2007 6:15 AM

manu said:

yeeeaaaaa.

this is my database!!!

# December 12, 2007 6:15 AM

Pedro Cunha said:

É ótimo para treinamento em programação.

# May 3, 2008 9:11 PM

elghoulu said:

i search for this every where  but you help me

# July 9, 2008 8:09 AM

uygar said:

How can I use this database I run the msi but nothing changed

# July 15, 2008 2:45 AM

Ahmed said:

Thanks a lot buddy

# July 30, 2008 4:51 AM

Diego said:

how can i use Northwinds in 2005

# August 28, 2008 2:50 PM

sridevi said:

i am not able to attach this .mdf file to my SQL server 2005 databases. i dono wat the problem is.

# September 19, 2008 4:49 PM

Michael said:

Could someone show me how to load the pubs database from a file called 'pubs.sql'  into  Sql 2005 Express?

# March 11, 2009 6:41 PM

angel_is_yours said:

what about Accounting for Sql 2005

# March 20, 2009 5:29 PM

Mallekoppie said:

Thanks. Worked perfectly

# March 24, 2009 5:34 AM

Reza Kaviany said:

Tanks * 10000000000000 = ?

# May 1, 2009 7:39 AM

mozafar said:

very good

all OK oK ok

# June 4, 2009 4:10 AM

Soha said:

Many thanks to you

# June 11, 2009 12:22 PM

MinhHai said:

Thank for this infomations. its userful..

# August 13, 2009 11:17 AM

sat said:

i want to learn sql strongly.

# September 2, 2009 5:18 AM

Noman said:

yes it worked thanks

# October 5, 2009 5:04 AM

omarnunezaguirre@hotmail.com said:

necesito practicar sql 2005,  con las bases de datos northwind y pubs,  please enviarmelas a mi correo

omarnunezaguirre@hotmail.com

# October 29, 2009 12:05 PM

9900tw said:

台灣網站導航

www.9900.com.tw

# January 23, 2010 9:16 AM

anil said:

I have same problem with sridevi

"i am not able to attach this .mdf file to my SQL server 2005 databases. i dono what the problem is."

# February 2, 2010 4:49 AM

hosseinesaboonchi said:

TANX

www.poroge.com

# April 8, 2010 10:43 AM

jayanthimurugesan@yahoo.com said:

Very Nice Information. Thank you.

# May 31, 2010 7:30 PM

jayanthimurugesan@yahoo.com said:

Tip to attach Northwind or Pubs.

1. Install SQL Server Management Studio Express.

2. Install SQL2000SampleDb.msi.

3. Open SQL Server Management Studio Express.

4. At the Object Explorer right click databases

5. Click Attach.

6. At Attach Databases window click Add button to attach mdf files.

# May 31, 2010 7:47 PM

mahnaz said:

salam man project mohandesi narm afzar mehkam (f daneshka)

# June 3, 2010 2:32 AM

Beee said:

Thanks jayanthimurugesan. I was able to import my adventuresWorks on the MS SQL server.

# March 14, 2011 10:03 PM

Isman said:

Thanks for these information

# August 9, 2011 12:35 PM

Lea said:

I am glad that it turned out so well and I hope it will continue in the

future because its so worthwhile and meaningful to that the community.

# January 11, 2013 8:52 AM

rahimullah said:

I need for using this data base

# March 17, 2013 3:15 AM