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 27, 2012 at 6:50 am

    #1571849

    dedicatedtosql (12/26/2012)

    Thank you very much for the advice.

    Actualy We have both CDC as well as Auditing in place for the prod database. But this was a local environment. Where we have many sysadmins. I know it is a worst practice. I am new here and I adviced them not to. But they want it to stay this way.

    Regards

    Looks to me like you need to set up auditing and CDC in this environment as well.