Audit Trails and Logging Part II

Question

Audit Trails and Logging Part II

Viewing 3 posts - 31 through 32 (of 32 total)

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

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

_UB SSCrazy Points: 2987 More actions · Answer 2

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

Abrar Ahmad_ SSCarpal Tunnel Points: 4244 More actions · Answer 3

[font="Verdana"]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?

[/font]