In the case of tablockx, the table is locked until the stmt or trans ends. What if in between there is an error, would that create a deadlock situation? Or would the table be released back to its orignal state when it encounters a err_handler event that takes it out of the procedure...

-- Anonymous, September 03, 2004

Answers

George,

I tested this and found that, as you suspected, the table is released back to its original state when it encounters the error.

Hope this helps,

Eric

-- Anonymous, September 04, 2004