"Kevin Yu" <koo9@hotmail.com> wrote in message
news:uUhH97%23eFHA.892@tk2msftngp13.phx.gbl...
> hi all
>
> got a situation here, there are 3 app server that are running a same
> application to delete records in the sql server
> periodically. what happen is that they all start up at the same time to
> delete records on the same table.(this could be fixed by varying the start
> up
> time on each app server for that application, but it's not a prefer
> solution.)
>
> so there is this error:
> transaction (process ID #100) was deadlocked with another process and
> has been chosen as the deadlock victim. Rerun your transaction."
>
> now I have read some article online saying putting a "with (UPDLOCK)"
> after
> the FROM <some table> will
> fix the problem.
>
> does anybody have the similar experience? what would be a perfect fix?
>
>
> thx
>
>
> Kevin
>
>
>