select Operation,fn_dblog.[TransactionName],[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'
andfn_dblog.[TransactionName] = 'DROPOBJ'