SQL server - TabLockXgreenspun.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