use tempdb

go

SELECT

[Current LSN],

[Operation],

[Transaction ID],

[Description], SPID,[Begin Time], [Transaction SID],

name 'LoginName'

FROM fn_dblog (NULL, NULL),

(select sid,name from sys.syslogins) sl

where [Transaction Name] LIKE '%delete%' and [Transaction SID] = sl.sid

my be it help's

Regards,

Satyam