Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server SMO/DMO

READ LDF FILES

I would like to know is it possible and how to read LOG files with SQL-DMO?

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,

[615 byte] By [ismar] at [2008-2-7]
«« Creating a mobile web application
»» Problem in overriding or adding methods in Collections .Can you help?
# 1
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.

MichielWories at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server SMO/DMO...
SQL Server
SQL Server SMO/DMO

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified