May 2, 2005 at 12:01 pm
Dear Users
How can we do log mining in SQL SERVER2000.
I did not create a SQL trace and I need to know which update statement update the value of one table.
How can I know the statement and which user issue this “UPDATE: statements?
Is any option to trace the logfile and identify all the statements that is executed on logfile.
Sorry for explain oracle information here.
Oracle having a tool called “LOG MINER” and using that tools we can know each statement that is executed on the database. Log Minier we can see the REDO and UNDO statement and we can trace any worng update/ insert.
Is SQL Server supporting any kind of tools.
Waiting for your reply
Mathew
May 2, 2005 at 12:07 pm
If you want to review the T-LOG I believe you will need a 3rd party tool (I assume that is what LOG MINER) does..
If you want to know who/what/when without spending money on a tool you will need to build in audit trails to write to an audit table to provide that information for you.
Good Hunting!
AJ Ahrens
webmaster@kritter.net
May 3, 2005 at 2:04 am
Dear Sir,
Thanks for your reply.. I will go for auditing in SQL Server..
Regards
Mathew
May 3, 2005 at 5:50 am
Hi Guys
Another tool that you can use is LogExplorer. you can get trial versions of this tool to test it out but its the closest I have seen to Log miner...
M
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply