hi2u (11/19/2012)
Does the trigger keep the initial (TABLOCK, XLOCK) or the lock is released and another one is made for the trigger?Thanks
Yes to maintain the atomicity there will be seperate LOCK
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)