My clients would like to know who is doing what and when. Actually I would like to trace table activites these are DELETES, UPDATES & INSERTS only. Also I know that it is possible to do it with triggers & jobs by creating new tables but imagine you have a database with size greater then 10 GB. It wouldn't be a good solution at all.
Thanks in advance,
SQL-DMO does not have that capability.
However, SMO has a namespace, which allows you do to live capture of trace data. See the Microsoft.SqlServer.Management.Trace namespace in Books Online.
However that is not reading LDF files, but starting a trace. If you want to read log files there are various 3rd party product out there that offer that capability.
