The best office I worked in was also one of the scruffiest.

It was at Defra (a UK govt dept) and was a site that had been built, but never used,...

Hi Amit

I embedded them in my last post. I could email the originals to you, if you can't see them in the post itself.

I'll send you a private message with...

Hi Amit

I've done 0, 1 and 2. This is what I get:

What should I be looking for?

rgds

Mark

I used SS Management Studio Express to make a create script for the BOOKING table, then modified it to create BOOKING2.

If I try an update against BOOKING2, it works. But...

I tried modifying the creation script so that the other tables' FKs weren't created, and still got the problem until I dropped and recreated the BOOKING table.

However, that's not quite...

It just shows the SQL command.

In the Status column it says "runnable". According to SQL Server Books online, this means the process is currently doing no work.

All very odd.

I tried...

Wait Time = 0, Wait Type is blank, CPU=591702, Blocked By=0, Blocking=0

...and yet it's still running. 26 minutes so far.

regards

Mark

Thanks for the command.

Yes, 53575229 is the BOOKING table.

regards

Mark

There aren't any triggers on the Booking table.

How do I find out if 53575229 is the Booking table?

thanks

Mark

Under Process Info, there are three process ids. The one for the UPDATE has Database=LBMS, Status=runnable, Open Txns=1, Command=CONDITIONAL.

Under Locks by Process, this process has

OBJECT, 53575229, IX, LOCK, GRANT, TRANSACTION

DATABASE,...

Another car game when you have two kids in the car is counting the Eyes on pub signs.

E.g. you pass the Green Man pub on the left. In the pub...

You can also play the "Non-Association" game, where the next player has to say a word that has no association at all with the previous word (and also no association...

As you say, the Country game is good for the kids' geography.

When we have a family meal we usually play "the Word game". One person chooses a letter, and the...