Post reply

Any way to find all deletes done on a table in last 24 hours?

  • April 20, 2011 at 2:17 am

    #389326

    Hi,

    I was wondering if there is a way to find all the deletes done to table or database in the last x amount of time. Is this info stored somewhere or does it need triggers set up for it?

  • April 20, 2011 at 2:19 am

    #1313784

    It needs a trace or a trigger, or if you're in full recovery model and have log backups, you could buy Apex SQL log (~$1000)

    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

  • April 20, 2011 at 2:25 am

    #1313785

    Thanks Gila,

    I didnt think there would be an "Easy solution"

    Thanks for the help

    S

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

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