Monitor INSERTs, UPDATEs, or DELETEs?

  • 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!

  • 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
  • Change Data Capture, Change Tracking

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

  • 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