Humble:

trying out your third example.
Gives me the following error when I try to run:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
   at System.Data.DataSet.FailedEnableConstraints()
   at System.Data.DataSet.EnableConstraints()
   at System.Data.DataSet.set_EnforceConstraints(Boolean value)

I really do no understand why.
I will continue working on this.

Regards, i

Humble:

Success with the Update!
Thank you! Did follow your example (3) and created the database/tables in the Manager.

Just have to write that down and put it in my book!
Hopefully you will visit this forum more, there might be surprises along the way (c;=

Regards, Ingimar

Hello Humble, Sturdy.

The upgrade worked.

Now I would like to work with my database again in the Management Studio Express.
First I did not get connected, due to the fact that the IDE was connected to my database.
This is what I assumed.
Closing down the IDE, trying to open my database in the Management Studio Express.

The Management says that the database is used by another process ....
Which process would that be ?
The Log says:
2006-03-23 09:59:17.00 spid51 Fel: 17207, allvarlighetsgrad: 16, tillstånd: 1
2006-03-23 09:59:17.00 spid51
FCB::Open: Operating system error 32(Det går inte att komma åt filen eftersom den används av en annan process.)occurred while creating or opening file
'C:\Program\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MyDatabase.mdf'.
Diagnose and correct the operating system error, and retry the operation.


This will probably work if I turn off the computer and start it all over ....

Any suggestions, or do you know of other forums just dealing with SQL Server ?

Regards, Ingimar

Hi Humble Weeble,

I, too, spent a day trying to understand why the chapter 3 and chapter 4 sample did not update. I tried your solutions #1 and #2 and they worked for me.

It was a big help and time saver to read your post.

Thanks.

search words: chapter 3 chapter 4 update does not work no update