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.
Comments
2 comments
-
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. -
ok thanks. I have used the trial version of ApexSQL Log 2014, and it worked really well.
Add comment
Please sign in to leave a comment.