查询谁删除了表数据_sql server_数据库_思韵闪耀_一生受益

这里是普通文章模块栏目内容页

查询谁删除了表数据

思韵闪耀

2013-12-13 00:00:00

0次

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%'

来自：How to find user who ran DROP or DELETE statements on your SQL Server Objects

上一篇： SQLServer job日志丢失

下一篇： SSDT:数据库部署方案

栏目索引

相关内容