Gerard,

I mean actual SQL text columns (aka memo fields). Regular char, varchar, etc columns audit normally.

Kurt


>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