Weird Update problem

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 1

Try this.

0. run update statistics with fullscan on all tables involved (by means of PK/FK)

1. run a sql profiler trace before running update. include execution plan events (showplan all and showplan statistics)

2. run update.

That would tell if there is a set of recursive triggers goging on or the update is picking up some bad execution plan

"There is no 'patch' for stupidity."

Mark Lines-Davies-427778 Old Hand Points: 334 More actions · Answer 2

Hi Amit

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

What should I be looking for?

rgds

Mark

Amit Jethva SSCarpal Tunnel Points: 4707 More actions · Answer 3

can't see ur image files

"There is no 'patch' for stupidity."

Mark Lines-Davies-427778 Old Hand Points: 334 More actions · Answer 4

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 my email address.

thanks

Mark