Hi Kurt
Thanks for your help
Regards,
Gerard



>Gerard.
>
>I'm not really certain what their licensing is since we only use it for 1 production database. Here's what there web site says about ISV's:
>

>OmniAudit ISV License   (contact us)
>ISV licensing is designed for software publishers who intend to bundle OmniAudit with their own commercial software as a way of adding audit trail functionality to their software. 
>Contact us for details about ISV licensing. 
>

>
>It's not that difficult to write your own triggers for each table that basically does the same thing as the OmniAudit manager software. With a little ingenuity, you could even write something that looks at all of the tables in a database and creates the triggers automatically. When we purchased the product, it wasn't cost effective for us to write our own for a single db with 300+ tables.
>
>Kurt
>
>>Hi Kurt.
>>I had a look at their web site and all documantation seems to be up to 2011.
>>Also insalled a trial version
>>I also dropped them an email about 2 days ago but have not got a response yet
>>Do you know if they are still in business
>>
>>Cost seems to be about $400, which would be fine, but does not seem to be for a 'Deploy Anywhere ' license
>>I am looking at this for upto maybe 60-70 sites and this would definitely break the bank !!
>>Do you know for sure if I set up a Database (in development) and deploy this to numerous sites, I have to pay for each site ?
>>
>>Regards,
>>Gerard
>>
>>
>>>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