Hi Kurt
Thanks for replying.
When you say 'Text' columns, do you mean Char(x) and Char(max) columns ?
Regards,
Gerard
>We use OmniAudit. It works pretty well, except it doesn't audit text columns
>
>
http://krell-software.com/omniaudit/>
>
>Kurt
>>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