Post reply

How to know who truncated a SQL Server Table?

  • December 30, 2011 at 7:58 pm

    #262241

    Hi All,

    I am just curious to know is there anyway we can track down who has truncated a particular table in SQL Server 2008 R2? I would require this information as part of some need in my project.

    Thanks,

    Srini

  • December 30, 2011 at 9:40 pm

    #1427155

    Check this article:

    http://msdn.microsoft.com/en-us/library/dd392015.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • December 31, 2011 at 1:23 am

    #1427185

    If somebody has already truncated the table and auditing is not in place then it’s difficult to track the user. If it’s just a thought & you want to safeguard your database for such actions, follow the article suggested by Jason.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply