sqlserver查看操作日志

    select Operation,fn_dblog.[Transaction Name],[Transaction ID],AllocUnitName,[Server UID],fn_dblog.SPID,fn_dblog.[Begin Time],p.nt_username,p.loginame,p.program_name from fn_dblog(null, null) fn_dblog join sys.sysprocesses p on p.spid=fn_dblog.SPID and fn_dblog.[Begin Time] >= '2013/08/09' AND fn_dblog.[Transaction Name]= 'DELETE' ORDER BY fn_dblog.[Begin Time] desc