Home Forums SQL Server 2008 SQL Server 2008 Administration Using ::fn_dblog() to find who deleted the rows in a table. RE: Using ::fn_dblog() to find who deleted the rows in a table.

  • December 25, 2012 at 5:44 pm

    #1571464

    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

    this query is not showing any results though the rows got deleted from the table. I have few rows from the table and checked it. Its not giving any results with details who has deleted them.

    Can you please help on this.