Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitor INSERTs, UPDATEs, or DELETEs? Expand / Collapse
Author
Message
Posted Saturday, June 29, 2013 11:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 17, 2016 11:56 AM
Points: 100, Visits: 389
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!
Post #1468813
Posted Saturday, June 29, 2013 11:55 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 2:54 PM
Points: 45,064, Visits: 43,153
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

Post #1468814
Posted Saturday, June 29, 2013 12:04 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, October 25, 2014 7:53 AM
Points: 729, Visits: 342
Change Data Capture, Change Tracking

http://msdn.microsoft.com/en-us/library/bb522489%28v=sql.105%29.aspx
Post #1468815
Posted Saturday, June 29, 2013 12:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 17, 2016 11:56 AM
Points: 100, Visits: 389
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!)
Post #1468818
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse