Begin Tran
Update MOD08.dbo.dltable SET col1 = 1

BEGIN TRAN
UPDATE MOD08.dbo.DLLock SET col1 = 1
UPDATE MOD08.dbo.DLTable SET col1 = 1

UPDATE MOD08.dbo.DLLock SET col1 = 1


BEGIN TRAN
UPDATE tempdb.dbo.DLTable SET col1 = 1

BEGIN TRAN
UPDATE tempdb.dbo.DLLock SET col1 = 1
UPDATE tempdb.dbo.DLTable SET col1 = 1

UPDATE tempdb.dbo.DLLock SET col1 = 1