Post reply

Monitor INSERTs, UPDATEs, or DELETEs?

  • June 29, 2013 at 11:45 am

    #276790

    Hi All,

    I have a particularly important table, and I need to know when anything about it changes. Would someone mind providing guidance on how to monitor this (preferably using SQL)? I'm hoping for something that will either send me and email, write to another table, or something along those lines. Any help is appreciated. Thanks!

  • June 29, 2013 at 11:55 am

    #1628506

    Change Data Capture, Change Tracking, triggers. All viable options.

    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

  • June 29, 2013 at 12:04 pm

    #1628507

    Change Data Capture, Change Tracking

    http://msdn.microsoft.com/en-us/library/bb522489%28v=sql.105%29.aspx

  • June 29, 2013 at 12:38 pm

    #1628509

    Excellent, that's exactly what I'm looking for. (Seems very standard; I'm not sure why my Google searches didn't find it. Must have been using the wrong search terms!)

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

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