Re: [cfaussie] Database Changes

Here here! Mark On Thu, Aug 19, 2010 at 8:37 AM, Barry Beattie wrote: > > This is one of the reasons I like the concept of AOP - squeeze in > there to add auditing/logging without mucking up too much code. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.

Re: [cfaussie] Database Changes

Dale: does it have to be done at the DB level, or can it be via the DAL? This is one of the reasons I like the concept of AOP - squeeze in there to add auditing/logging without mucking up too much code. On Thu, Aug 19, 2010 at 8:30 AM, Scott Thornton wrote: > easy no,  possible yes. > > > > ch

RE: [cfaussie] Database Changes

easy no, possible yes. check out www.sqlservercentral.com for some auditing techniques. I audit quite a few of the fields in certain tables within my application. This is done via triggers, inserting changes into an audit table: eg: ALTER TRIGGER [tablename_UP