Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Audit Trails and Logging Part II Expand / Collapse
Author
Message
Posted Monday, August 04, 2008 12:06 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 PM
Points: 15,442, Visits: 9,588
Some expansions on this subject at:

http://www.sqlservercentral.com/Forums/Topic536927-145-1.aspx


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #546292
Posted Thursday, August 13, 2009 11:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 12:30 PM
Points: 297, Visits: 437
Gsquared,

Thanks for the informative article.

One question though. My question is to know if there is any advantage of one method over the other. Or is it just preference (...I say toMato and you say TomaTo case)

In part II, active logging with triggers, on INSERT the code stores the INSERTED record. On DELETE, it stores the DELETED record. But on UPDATE it stores the new record from the INSERTED table rather than the row that is being deleted.

I've always stored the row that is being deleted (i.e. from DELETED table except for INSERT).

I see both methods to be of same value. but wanted to know what you think of it.

thanks,
_UB


SqlTimes Blog on Sql Server
Post #770381
Posted Friday, July 23, 2010 4:33 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:51 AM
Points: 209, Visits: 1,085
I am curious, that no one has yet commented over CDC feature built-in in SQL Server 2008?
It is not such out off the domain of Auditing?

Please?

Post #957861
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse