begin tran update db1.dbo.foo set bar = 1 where baz=2 delete db2.dbo.bar where baz=2 commit tran