I'd stick with RLOCK() rather than relying on automatic locking. If you use automatic locking and the GATHER fails you're TRY/CATCH can't retry the operation (which, assuming the fail was just due to a multi-user conflict, would almost certainly succeed).


Yeah, that's a good point. I hadn't thought of that when I originally wrote this.

Thanks,

Michelle