怎样使用SQL语句查询SQLSERVER系统日志

SELECT  *, allocunitname,operation,[RowLog Contents 0] as r0,[RowLog Contents 1] as r1 FROM Fn_dblog(null,null)where allocunitname like'dbo.表名'and operation in('LOP_INSERT_ROWS','LOP_DELETE_ROWS')

posted @ 2011-08-03 11:11  cyb  阅读(2879)  评论(0编辑  收藏  举报