Friday, February 24, 2012

Log all updated tables

We have a third party process that runs and updated several SQL tables.
Is there any way to find out what tables are being updated and store it in another table?IF you are running MS-SQL 2000, then use SQL Profiler.

-PatP|||I thought of that but they want this to run all the time. And profiler can cause some overhead. Is there any way to view what's in the transaction log?|||My first thought would be Lumigent Log Explorer (http://www.lumigent.com/products/le_sql.html), but there are options involving triggers that could also do what you've described.

-PatP|||You can take help of server side trace, as the PROFILER is a resource intensive operation.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm & KBA http://support.microsoft.com/?kbid=822853

No comments:

Post a Comment