http://tinyurl.com/a2px6r5>Hi.
>In VFP, I have a table with columns:
>Updatetype,TableName,ColumnName,OldValue,NewValue,UserId,When
> to implement auditing and anytime data is written to ANY table, this Audit Table is updated.
>
>Does anything like this exist in SQLSERVER (without any coding)
>With Coding, what would be the best approcah to accomplish this
>(I will need to populate the UserId, which will be application specific)
>
>Tia
>Gerard
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer