SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2

June 15, 2007 by pinaldave

I have mentioned the history of NorthWind, Pubs and AdventureWorks in my previous post SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases. I have been receiving very frequent request for NorthWind Database for SQL Server 2005 and installation method.

Follow the steps carefully and it will install Northwind and Pubs database in SQL Server without any issue. I have tested all the three method on my home computer and attached the screen shots as well.

Common Step for all the 3 methods

First, go to Microsoft Download Center and download SQL2000SampleDb.msi.
Run SQL2000SampleDb.msi it will create “C:\SQL Server 2000 Sample Databases” folder.
Now follow any of the following three method to install this databases. I have listed methods in order of my preference.

Method 1: Running SQLCMD
Navigate to this folder using command prompt. Start >> Run >> C:\SQL Server 2000 Sample Databases.
If you have installed SQL Server as named instance run following command.

c:\>sqlcmd -S .\InstanceName -i instpubs.sql
c:\>sqlcmd -S .\InstanceName -i instnwnd.sql

If you have installed SQL Server as default instance run following command.

c:\>sqlcmd -i instpubs.sql
c:\>sqlcmd -i instnwnd.sql

Verify that NorthWind and Pubs database are installed correctly.
Method 2: Running SQL Script
Open SQL Server Management Studio. Go to File >> Open >> Navigate to “C:\SQL Server 2000 Sample Databases\instpubs.sql” and “C:\SQL Server 2000 Sample Databases\instnwnd.sql” and run those sql file in order. This will install the database.

Verify that NorthWind and Pubs database are installed correctly.

Method3: Attaching the Database
Move Northwind and Pubs database files (MDF and LDF files) to your default database file location (usually – C:\Program Files\Microsoft SQL Server\MSSQL\Data).
Open SQL Server Management Studio. Expand the database node >> Right click on Databases >> Click on Attach >> Select NorthWind Database. It will automatically find MDF and LDF file. Click OK.

Repeat the process for Pubs and verify that NorthWind and Pubs database are installed correctly.

Reference : Pinal Dave (http://blog.SQLAuthority.com) , Read-Me file in installation folder, BOL

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology | Tagged SQL Sample Database | 118 Comments

118 Responses

on June 26, 2007 at 8:27 pm Jason

Hey, kudos on this information. I was able to install both pubs and northwind in minutes :)
on July 3, 2007 at 9:26 am Abi

U r the best teacher. U made the installation of both Northwind and Pubs so easy. Thanks.
on July 6, 2007 at 1:51 am Alex

Good information. Thanks.
on July 13, 2007 at 4:23 pm Ritesh

Jo Buddy,

This is good article, just wondering if you can elaborate why there is not change when you copy mdf, ldf file of MS 2000 in MS 2005 there is not effect.
on July 29, 2007 at 5:35 am Dipsy

This site has been a great help to me.
Good work… Keep it up!!!
on August 7, 2007 at 9:41 am Aarts

yahooo…i could successfullly install Northwind and Pubs
on August 7, 2007 at 9:45 am pinaldave

I enjoy writing this post.

Glad to know that this is helping.

Kind Regards,
Pinal Dave (http://www.SQLAuthority.com)
on August 23, 2007 at 9:35 am Doug Thornton

Dear Pinal Dave,
I have purchased “The Guru’s Guide to Transact – SQL” by Ken Henderson at the advice of my supervisor. Ken recommended installation of the two databases, so I found your site on the net. The installation was easy and the two new databases appeared in the Object Explorer window of my Microsoft SQL Server Management Studio. However, when I tried to open each of the databases, I got a message box as follows:

“The database Northwind is not accessible”
“The database pubs is not accessible”

Perhaps you can reply with explanation of how I should gain access to these two new databases. I offer my thanks in advance to your reply, and certainly appreciated your help with the installation.

Sincerely,
Doug Thornton
Systems Integration Programmer
on August 23, 2007 at 3:21 pm Doug Thornton

Pinal Dave,
I answered my own question, as I just had to authenticate via Windows instead of SQLServer when logging in using Management Studio. Access to databases complete !!!
Doug Thornton 082307
on August 24, 2007 at 11:54 am pinaldave

@Doug,

You can use SA username and password to login.

You can create username and give permission to access those database.

Regards,
Pinal Dave ( http://www.SQLAuthority.com )
on August 29, 2007 at 8:59 am Jatinder

How do I Verify that NorthWind and Pubs database are installed correctly at the end?

I can load both databases and then I seem to be stuck on what to do next.

I am using method 2.

Also is this safe to do as I am connected to my workplace master database and do not want to affect anything in there.

Thanks Pinal

Jatinder
on August 29, 2007 at 9:07 am pinaldave

Hi Jatinder,

Open the database and run select statement on any table. It should help.

Regards,
Pinal Dave ( http://www.SQLAuthority.com )
on August 29, 2007 at 9:20 am Jatinder

I cant seem to select statement. This is first time I’ve used SQL, hence why i’m not grasping it as easy as other people.

Can you show me please? tks
on September 11, 2007 at 11:18 am MW

I do not have a C: drive. How in the world can I extract the files I need from the .msi?

Thanks.
on September 14, 2007 at 10:51 am Mircea

Hi
I have the same problem… I don`t have a C: drive. What can I do?

Regards, Mircea
on September 24, 2007 at 12:35 am Anamika

Thanks for the info was able to install northwind w/o any trouble
on September 29, 2007 at 10:33 am Jason

Once the Northwind database is installed, how do I go about getting/setting the admin username and password as well as other usernames and passwords?

Thanks
Jason
on October 3, 2007 at 1:26 am Marthinus

Thanks SO much – works VERY well- JC bless you!
on October 17, 2007 at 12:34 pm Franklyn Urey

Excellent help. It was easy and fast.
And by the way, the first method is the best.
on October 26, 2007 at 5:21 am dhina

thankx very much. got my solution in the first try! :)
on October 31, 2007 at 4:21 am Yuva

Hi ,

i am getting the follwing error when i tried to attach Adventure Works Database.

——————————
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

——————————

Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database ‘AdventureWorks’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

——————————

Please Help.

Thanks In Advance
on November 1, 2007 at 4:11 am Nirmal Shah

Hello Pinal,

I am beginner of sql server 2005 and to the stored procedure.
I have created simple stored proc.
but it gives me error like
“The specified schema name “hr” either does not exist or you do not have permission to use it.”

i hv given the sp name hr.try
database is Nirmal
and table name is unamepass.

I am waiting for your response

Thank you very much
Nirmal Shah
on November 7, 2007 at 8:41 pm Miroslav Trecha

Hello Yuva,
this error message appears when you try to attach a Microsoft SQL Server 2005 database in SQL Server 2000.

This behaviour occurs because attaching SQL Server 2005 databases in SQL Server 2000 is not supported. Upgrade your database server to SQL Server 2005.
on November 16, 2007 at 5:01 am magnolia

hi,
i was struggling to work this out..but ur diagramatic approach has fixed it..
good work!!!
on November 19, 2007 at 5:36 pm Ed Graham

I was looking all over for a SQL Server 2005 version of the Northwind database and couldn’t find it anywhere… thanks very much for your help!
on November 21, 2007 at 8:16 pm Jai

Hi I too have a problem similar to that posted by YUVA.
Getting the similar error as follows :
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

——————————

Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database ‘AdventureWorks’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

And I do see sql 2000 files on my system.
However I installed Sql server 2005 and am not able to attach adventureworks database into it.
I dont know how to Upgrade my database server to SQL Server 2005.
No option is available to remove sql 2000 from my system in add/remove programs.
I would appreciate if anyone would be able to get me out from this problem.
Thanks in advance.
on December 15, 2007 at 7:50 am crg

Didn’t see this mentioned — in Vista, if you’re executing sqlcmd from the command prompt, run cmd.exe as Administrator… otherwise the script will puke all over the place with ‘permission denied’ and ‘does not exist’ errors.
on December 15, 2007 at 5:06 pm Parshant

Yes I got what I needed
on December 16, 2007 at 1:48 am Murtaza

thankx very much. GOD BLESS U
on December 26, 2007 at 8:49 am sailaja

Very help full site. clean site with not much noise of ads and disctractions.

But have a question though? Why email is necessary to post feed back.
on January 15, 2008 at 3:35 am Bill Gibbs

Thank you so much for your commitment in providing this essential info…so many tutorials (ex. the ASP.NET 2.0 material I’m working with currently) is requiring the NWind db (and many legacy materials reference the Pubs db, of course), and to have such a clear resource to work with makes it a reality…and also reviewing the import scripts that create the db is a valuable exercise as well. CHEERS!
on January 17, 2008 at 12:56 am Srikanth

Thank you very much…..it is really helpful
on January 22, 2008 at 11:57 am Anubhav

Thanks Dave!!
Keep it Up.
on January 30, 2008 at 5:19 pm Srivatsa

Thanks man … !!!

Great job …
on February 15, 2008 at 11:31 pm George

Hello,
Can anyone specify how can I find sample cude from Sql Server 2005?
Thanks and regards
George
on February 18, 2008 at 9:02 am weixin

thanks, that is really what i want.
on February 23, 2008 at 8:06 am Rohit

Nice and user friendly. Thank you.
on March 5, 2008 at 2:46 pm Vishwanath

Very well done, Pinal. Wonderful job :-) This site is really very helpful.
on March 11, 2008 at 8:29 pm Adrian

Good article- not just the “what” but also the “why”.

Unfortunately trying to install the database files for use with Visual studio 2003 and sql server 2005 is a minefield and he has done his best to find a path through it.
on March 16, 2008 at 3:04 am Alex G

Excellent article – Most useful.
on March 25, 2008 at 8:01 am varu

I downloaded SQL2000SampleDb.msi and now I have SQL Server 2000 Sample Databases in my C drive. Then I tried executing this command in the command prompt

c:\>sqlcmd -S .\InstanceName -i instpubs.sql
c:\>sqlcmd -S .\InstanceName -i instnwnd.sql

but I got this error,
’sqlcmd’ is not recognized as an internal or external command, operable program or batch file.

the I tried the other set of command too
c:\>sqlcmd -i instpubs.sql
c:\>sqlcmd -i instnwnd.sql

again I got the same error.. cannot figure out why. Please help me
Thanks
on March 31, 2008 at 11:58 pm Harish

hey Pinal,

Thanks for this post..just the thing I was looking out for.

Give me a call anytime you land up in Ahmedabad, would be great to meet you…not that I’m a big techie..but i undestand whats going on :)

regards
Harish
on April 4, 2008 at 3:38 pm jemreal

thanks! great help.
on April 5, 2008 at 3:20 pm Hrvoje

For all those who are using Vista – you should start cmd with administrator privileges.
Go to C:\windows\system32\cmd.exe right clik and click “Run as Administrator”. Than firs option for installation threw command prompt will work just fine.
on April 8, 2008 at 1:13 pm gaurav T

great post. I successfully installed Northwind.

thanks,

gaurav
on April 12, 2008 at 6:19 pm Mario

Thanks man. Good help
on April 14, 2008 at 12:55 pm JainLal

I have developed an application in Visual C#.net 2005 it is connected to a Sql Server database at back end.Now i want to create a setup project which should first install my application as well as Sql server. i.e when i install my application it also installs Sql Server if it is not already installed.

How can i do this?

I will be very thankful.
on April 15, 2008 at 12:51 pm Akhil Kumar

Thanks!
on April 15, 2008 at 1:24 pm Sid

phew .. finally
many thanx
on April 16, 2008 at 11:47 am altins

Yay…

Thanks..

You rocks…!
on May 2, 2008 at 2:26 pm raff

thnx a bunch for this man.. very helpful, db sample install made simple ;-)
on May 22, 2008 at 11:00 am sonu

hi can an bod tell me how to set database on server when creating setup in .net .
on May 25, 2008 at 9:00 pm rypki

Thanks, I have succesffully instaled Northwind.
on May 29, 2008 at 9:01 pm Lucky

I am not able to download “SQL2000SampleDb.msi” from Microsoft url becuase of some security issues is there any other place where i can download it from
Thanks
on June 19, 2008 at 10:31 pm Sanyam

I am a newbie to sql server….

i found this information v v v v useful to install these databses…

thank you…
on June 20, 2008 at 12:25 pm Thilinasp

It really works. Thank U!
Cheers!
on June 24, 2008 at 11:49 am Sri Hari

This is an excellent stuff.

I’m learning SQL Server 2005 and ASP .NET, please help me to find any site which explains in such a simple English to learn, I’ll be glad.

Thanks in advance

Sri Hari A
on June 26, 2008 at 11:38 pm KdV

Hi Pinal Dave,

I followed your instructions to install the northwind database, it worked! Thank you very much.

You are the man!

Greetings from the Netherlands,
KdV
on June 27, 2008 at 9:19 am Nonie

Dear Bro,

Is there any impact if i delete Northwind and AdventureWorks db? I am not suppose to install it at my production db.
If yes, do i just right click on the db name and choose ‘delete’?

Thanks

Regards
on June 29, 2008 at 8:35 am ecards

Thanks a lot for making this easy -

My only wish would be that Microsoft would ship northwind as part of the SQL Server install!

Best regards,
Lee
on July 1, 2008 at 10:50 am Minakshi

I am someone who is entirely new in this field. Your article really did help me to install the two database. Thanks a lot.
on July 9, 2008 at 9:34 pm Adrian

Many thanks. Method 1 even worked! Just ensure you have closed down Visual Studio before you do it(Sounds obvious but I thought Id mention it.)
on July 17, 2008 at 12:28 pm Michael

Thanks for this good tutorial, it is cool!
on July 28, 2008 at 5:44 am urbain

my name is urbain, i am learning sql so please i need your help, can you please send me adventure works database download to my email which is so i can download it to my computer and i can practice and please i need your help
on July 31, 2008 at 10:49 am Gregory Howard

Excellent Article. I love it.
on August 4, 2008 at 7:34 pm Omar

Great. Thanks a lot. It was so quick to install the both databases.
on August 7, 2008 at 2:21 pm Abhijnan

gr88 job man.really helped me a lot
on August 8, 2008 at 10:11 am JJ

Hi:

I download SQL2000SampleDb.msi (288k).
But, I can’t run it.
It used ‘Windows installer’ to run that file and give me the following message.

“This installation package could not be opened. Contact the application vendor to verify that this is a valid Windows installer package.”

Can you tell me how to fix it? Thanks.

Regards,
JJ
on August 10, 2008 at 7:00 am SQL SERVER - 2008 - Download and Install Samples Database AdventureWorks 2005 - Detail Tutorial Journey to SQL Authority with Pinal Dave

[...] If you want to install AdventureWorks database version 2008, the methods works fine. There are additional sample database are available in the same package and they can be installed in similar way. If you want to install Northwind database follow my previous article SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2. [...]
on August 19, 2008 at 11:17 pm kemal can kara

vaoov your are the best, five problems i had and you solve all of them easily. Loves from Turkey
on August 21, 2008 at 11:11 am Fateme

Thanks a lot
on August 21, 2008 at 5:46 pm abs

hi i was trying to attach adventure works database but it gave me error stating failed to retrieve data for this request can u pls show some other way of attaching adventureworks database…
on August 23, 2008 at 6:42 pm SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases Journey to SQL Authority with Pinal Dave

[...] recommendation : Start getting familiar with AdventureWorks. UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using [...]
on September 2, 2008 at 6:15 am Sasidhar

Thanks a bunch,you saved me a lot of time.You made it seem so simple
on September 18, 2008 at 1:22 pm Arti

Sir, thanks for giving details about northwind and pubs….Can you tell me any site name to downlaod min 5000 Records.
thanks
arti
on September 20, 2008 at 12:09 pm Yimmy Rengifo

Desde Medellín, Colombia, Muchas gracias, EXCELENTE !Funciona perfecto.
:-)
on September 22, 2008 at 7:24 pm Daniel Freeman

According to the installation package, AdventureWorks installed correctly but I can not find it in order to attach it.

Also having trouble with attaching Northwind and Pubs. These I can find, but they fail to attach. I get the following message:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SQLServer.Express.ConnectionInfo)

Unable to open the physical file “C:\SQL Server 2000 Sample Databases\northwnd.mdf”. Operating system error 5: “5(Access is denied.)”. (Microsoft SQL Server, Error: 5120)

I am really in need of a fix for this. Thanks in advance.
on September 23, 2008 at 5:46 am Shavkat

Dear Pinal,

many thanks for instructions, they helped a lot. I did attach successfully Northwind and Pubs databases.

Kind regards,

Shavkat.
on September 27, 2008 at 4:15 am raja

thanks man it helped me!!!
on September 28, 2008 at 12:08 pm sagar

gv me sample databses
on October 2, 2008 at 9:28 pm Syed

gr8 …. thanks alot
on October 7, 2008 at 8:34 pm Julia

Hi Pinal -

You helped a lot! Great teaching skills – short and clear instructions. Thank you very much.

Julia
on October 15, 2008 at 4:09 pm Dhirendra Singh Sengar

Dear Sir,
I m dhirendra Singh from DRDA, auraiya(UP). Plz, send me your course details and fee structure. I join your group.

Dhirendra Singh
on October 16, 2008 at 9:53 pm Naga

Greate Job.!!
on October 23, 2008 at 4:40 am Mahua

Hey thanks for the information.
It helped me to attach the sample databases
on October 23, 2008 at 4:42 am Paris

thanks for what u do
on October 28, 2008 at 3:06 am Lalaine

hello,

will this work in SQL server 2005 express edition?
thanks!
on October 28, 2008 at 3:07 am Lalaine

is this applicable in the express edition? i wanted to use the northwind in my sql2005expressed.. thanks
on October 29, 2008 at 2:09 am rcuscaden

Thank you. Your example also works for SQL 2k8. Many thanks for your wonderful post.
on November 6, 2008 at 12:46 pm harinath clavib

Hi Dave,
can you explain how to configure Adveture works databasae in sql 2005.

and i need some help to extract full text from a column using prefix i tried but when i give 2 or 3 char for a word it shows blank why?

do explain

Thank you
on November 26, 2008 at 4:50 am santiago

Hi David, after hours looking and trying diferent things I finally found this site, I it took me 2 minutes to install pubs and nwnd, THANKS.
Santi
on November 30, 2008 at 7:51 am frank

thanks,
on December 2, 2008 at 12:39 pm Deep

Hello,
I m doing attach mdf file of sqlserver2000 to sqlserver2005 database but while attaching file, it is showing some error like..
mdf file is read only. you cant do this.
I also make file non read only but still it is showing the same.
Can you tell me the solution ??
on December 5, 2008 at 2:46 pm sivasree

Hi,

thankq very much for the instructions..easily installed northwind and pubs
on December 5, 2008 at 2:49 pm sivasree

hi deep,

Even i got the same problem…then i followed the method 2… with in 2 mins i installed the databases….
on December 6, 2008 at 9:34 am Sam

Thank you very much for the helpful tip on installation of the sample databases.
on December 18, 2008 at 1:16 pm seenu

hi
after connecting the sql srever2005 management studio express with windows authentication, i am try to attach northwind database i got this errors

TITLE: Microsoft SQL Server Management Studio Express
——————————

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

——————————
ADDITIONAL INFORMATION:

Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).
Could not load the DLL xpstar90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). (Microsoft SQL Server, Error: 17750)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=17750&LinkId=20476

——————————
BUTTONS:

OK
——————————

pls help me
on January 22, 2009 at 4:55 pm Jithesh

Thanks Pinal
on January 23, 2009 at 5:30 am JG

Thanks for help.
on January 25, 2009 at 3:04 pm Rakesh

Wow,easy way to install both Northwind and Pubs Databases for SQL Server 2005…Thanks a lot
on February 11, 2009 at 5:37 pm Vikram Nanda

For a fresher like me…this is a very very helpfull information
Thank’s a lot
on February 25, 2009 at 1:32 am Brulimat

It is very useful for a newbie. Thank you.
on March 2, 2009 at 3:30 pm vildan

Thanks a lot! Very usefull to me.
on March 14, 2009 at 4:02 am Aravind

Thanks a lot . it was really helpful
on March 20, 2009 at 5:33 am Musatya

I wish I had comea across this page a lot earlier. Its clear and concise. Thank you
on March 28, 2009 at 4:30 am Iraticus

Once again – The right answer and the whole answer. Thanks so much
on April 2, 2009 at 12:13 pm Hems

Thank you so much :) :) :)
on April 3, 2009 at 2:12 am Zain

thanks a lot man i was having problem in attaching these DB’s … THANKS ALOT
on April 17, 2009 at 9:57 am dee

Hi

Thanks a lot buddy..It worked for me..keep the good work up
on April 17, 2009 at 1:07 pm shekar

This is the best explanation one could ever give..thanks a lot..
but in the first method i am getting this error..thought i was able to run second method.can u tel me solution for this..

HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
on April 28, 2009 at 1:58 am PhilD

Great, worked as stated – very easy and quite handy! Thanks.
on May 11, 2009 at 4:56 am Sepehr

Thanks ! That really helped ! Good Luck dude !
on May 19, 2009 at 3:26 am kalyan

ur extremely superb.. I saved lot of my .. time to day.. thanks.. guys if ur missing the sql authority .. ur definitely missing a good one..

goodluck.
on May 19, 2009 at 3:32 am kalyan

hi,

I was trying to install advntureswork .LT from this link

“http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004″
from which i have installed advwrks.DW and advwrks.BI which worked really well but when I was trying 4r .LT it was installed but it says “read only ”

can i know how to install it perfectly.please help me.
on June 3, 2009 at 6:21 pm Sri

Thanks a lot Dave … It really helped me to install Pubs and Northwind
on June 9, 2009 at 12:07 pm uday kumar lazurus

Thank you very much Dave. tht was simple and very useful.
on June 20, 2009 at 5:06 pm Mohammed A. Fadil

Thank you very much pinaldave, the post was very helpful to me :)
on July 2, 2009 at 11:08 pm Divya

Hi Dave

I get this error when I try attaching the db.
Please Suggest.

Attach database failed for Server ‘DIVZ-PC\SQLEXPRESS’. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

——————————

Database ‘pubs’ cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)