查询谁删除了表数据


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58
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%'