SQL server - TabLockX

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

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



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,


-- Anonymous, September 04, 2004

Moderation questions? read the FAQ