Home Forums SQL Server 2008 SQL Server 2008 Administration How to know who deleted / when deleted data in a table in sql server 2008 r2 please RE: How to know who deleted / when deleted data in a table in sql server 2008 r2 please

  • April 10, 2014 at 12:49 am

    #1704759

    Hi,

    Please check the below link. It is showing how to get the user details who deleted the data from Transaction Log.

    http://www.mssqltips.com/sqlservertip/3090/how-to-find-user-who-ran-drop-or-delete-statements-on-your-sql-server-objects/

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams