select Operation,dblog.[Transaction Name],[Transaction ID],AllocUnitName,[Server UID],dblog.SPID,dblog.[Begin Time],
p.nt_username,p.loginame,p.program_name
from fn_dblog(null, null) dblog
join sys.sysprocesses p
on p.spid=dblog.SPID
--and dblog.[Begin Time] >= '2012/10/03'
and dblog.[Transaction Name] = 'DELETE'