解决方法
首先,您获得admintrace的位置：
select * from fn_trace_getinfo(NULL) where property=2 and traceid in (1,2,3,4,5) --sometime several logs available
然后你检查所有细节：
select DatabaseName,ObjectName,LoginName,StartTime,*
from fn_trace_gettable('c:\path_to_log\MSsql\Log\log_2.trc',-1)
where EventClass = 47 --Object:Deleted
