[dba-SQLServer] SQL 7 - Trigger Question

Arthur Fuller fuller.artful at gmail.com
Fri Jan 4 14:01:29 CST 2008


If you touch just one row at a time, you'll have one row in both inserted
and deleted. That was the principle behind our article that Susan's URL led
to: by comparing the two rows, you can tell exactly what changed and thus
create an audit trail.

Arthur

On 1/4/08, Joe Rojas <JRojas at tnco-inc.com> wrote:
>
> Hi Susan,
>
> Thanks for the link!
> It was insightful but not directly applicable to my issue...as far as I
> can tell. :)
>
> Joe Rojas
>



More information about the dba-SQLServer mailing list