Dear All,
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?
In SQL server having any option to Trace a log file and check the statement that is executed in SQL Server on a specific time? If Yes How can I do it?
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