本文重现了所有者id为65535的特殊情况,其操作者为sa,正常时所有者id为1
checkpoint
select [ current lsn], [operation],[context],[ transaction id],[object name],[page id],[slot id],uid,[ transaction name] from ::fn_dblog( null, null)
create table T1(id varchar(50) primary key,col1 bigint,col2 char(20));
insert T1 values( 'varchar', 2, 'char')
update T1 set id= 'varchar', col1=3, col2= 'char1'
update T1 set col1=3, col2= 'char2'
create table T2(id varchar(50) ,col1 bigint,col2 char(20) primary key(id,col1));
insert T2 values( 'varchar', 2, 'char')
update T2 set id= 'varchar', col1=3, col2= 'char1'
update T2 set col1=4, col2= 'char1'
update T2 set col2= 'char2'
create table T3(id varchar(50) ,col1 bigint,col2 char(20) primary key(col2));
insert T3 values( 'varchar', 2, 'char')
update T3 set id= 'varchar', col1=3, col2= 'char3'
update T3 set id= 'varchar', col1=4
create table T4(id varchar(50) ,col1 bigint,col2 char(20) primary key(col1));
insert T4 values( 'varchar', 2, 'char')
update T4 set id= 'varchar', col1=4, col2= 'char3'
update T4 set id= 'varchar1', col2= 'char3'
create table T5(col1 bigint,id varchar(50) ,col2 char(20) primary key(col1));
insert T5 values(2, 'varchar', 'char')
update T5 set col1=4,id= 'varchar', col2= 'char3'
update T5 set id= 'varchar1', col2= 'char3'
delete from t1
delete from t2
delete from t3
delete from t4
drop table t1
drop table t2
drop table t3
drop table t4
转载于:https://blog.51cto.com/dreamsky/103908