Home Forums SQL Server 2008 Security (SS2K8) 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.

  • Nope.

    The transaction log is not an audit log, it is not important for database recovery or transaction rollbacks what login did the operation, that information is not included in the log at all.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass