Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    37

    Unanswered: Find who delete the data

    Hi,
    Please help me on this,
    how to find who delete/Truncate the data from table ,because i dont have any trigger on the table.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Without some form of logging in place either at a table or database level then there's no way to work back and see who did what.

    It's analogous to trying to catch people speeding down a highway the month before you installed a camera to do so.
    George
    Home | Blog

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    TRUNCATE TABLE will not activate a delete trigger because the operation does not log individual row deletions.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Feb 2013
    Location
    perth australia
    Posts
    24
    hi,

    from sql 2008 onwards, using sql server auditing is the preferred method instead of triggers to audit server/database activity.

  5. #5
    Join Date
    Aug 2008
    Posts
    147
    In your circumstances , there are some differents to use - which may give you enough clues in identifying the logon - check Last DML operation - SQL Server DBA
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    There are ways to find all of the instances of the word TRUNCATE in stored procedures and sql jobs. Would that be helpful?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •