Hi Mike,

I'm not using transactions at all. What bothers me most is that the problem doesn't occur all the time (with the same data).
I will have a look at sp_who and sp_locks.

Thanks,

Martin

>>No, I don't get an error.
>
>Maybe there's a logic issue somewhere? On a long shot, are you using savepoints from distributed transactions?
>
>>> I'm not sure how to determine if the connection is blocked.
>
>Use sp_who and look for a value in the BLK column. Use sp_locks for more details on the locks currently held on various objects.
>
>-Mike