which app does SQL Log Rescue jobs

EuniceR03

I was looking at SQL Log Rescue, and wonder which current product performs roughly the same tasks. What I wanted in this particular case is I wanted to look at the logs and find out which user updated many rows of a particular table.

Colin Millerchip

Hi,

I'm afraid that Red Gate doesn't have an alternative product to recommend. I'm aware of one other 3rd party product in this space from ApexSQL; also, there are some undocumented functions in SQL Server that might help - here are a couple of articles on the web that might be of interest:
http://www.sqlservercentral.com/articles/Transaction+Logs/71415/
http://stanleyjohns.wordpress.com/2012/01/09/reading-the-transaction-log-using-fn_dblog-and-fn_dump_dblog/

Best regards,


Colin.

EuniceR03

ok thanks. I have used the trial version of ApexSQL Log 2014, and it worked really well.