用微软未公开函数::fn_dblog查看日志
SELECT allocunitname,operation,[RowLog Contents 0] as r0,[RowLog Contents 1]as r1
from ::fn_dblog (null, null)
where allocunitname like 'dbo.manager%' and
operation in('LOP_INSERT_ROWS','LOP_DELETE_ROWS')
SELECT allocunitname,operation,[RowLog Contents 0] as r0,[RowLog Contents 1]as r1
from ::fn_dblog (null, null)
where allocunitname like 'dbo.manager%' and
operation in('LOP_INSERT_ROWS','LOP_DELETE_ROWS')