Help searching through transaction logs

[web4fun]

Need a way to search through SQL Server transaction log files to find out when a particular table in a specific database; i.e. table 'abc,' was updated. Has someone written anything that might be able to accomplish this; i.e. a store procedure?

Reason for this is that we had a sql hack which updated one of the tables with some problematic values and we need to find out when the update occurred.

Thanks in advance.

 

[yelworcm]

You can look into Lumigent's Log Explorer. Cost is fairly cheap, I think. At least for most values of "cheap".

 

[web4fun]

Thanks very much, was hoping to find a script / stored procedure.

 

[mrdenny]

There's no way to read the transaction log from a stored procedure.

You can use SQL Profiler to monitor what's happening on the system in real time. Or you can setup a trigger on the table and have it log data into another table to log who made a change, and what they changed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[web4fun]

Thanks mrdenny. I was able to find RedGate's SQL Log recovery tool and it's great...had just what I was looking for.