查询谁删除了表数据

SELECT  AllocUnitName,
[Transaction SID], SUSER_NAME([Transaction SID]) Who,
Operation,[Transaction Id],[Transaction SID],
[Transaction Name],[Begin Time],[End Time],[SPID],Description
FROM fn_dblog(NULL, NULL) 
WHERE Operation = 'LOP_DELETE_ROWS'
AND AllocUnitName NOT LIKE 'sys.%' AND AllocUnitName NOT LIKE 'Unknown Alloc Unit%'
 

相关文章

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注