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