
create database demo
go

use demo
go

drop table t1

create table t1 (
 id int primary key,
 name varchar(10)
)


create table t2 (
 id int primary key,
 name varchar(10)
)


create table t3 (
 id int primary key,
 name varchar(10)
)

insert t1 values(1, 'foo')
insert t2 values(2, 'bar')
insert t3 values(3, 'baz')

-- execute the updates one at a time
begin tran
update t1 set name = 'foo2'
update t2 set name = 'foo2'

rollback


sp_who2
