Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mchry99
Starting Member
6 Posts |
 Posted - 2005-05-02 : 13:44:12
|
| Dear Users,How can i do log mining(Trace the log and Identify the statement executed on a specific time) in SQL SERVER2000.I did not create a 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?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 replyMathew |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-02 : 16:08:13
|
| You can use SQL Profiler to view the activity. To read the transaction log, you'd need a third party tool, such as Lumigent's Log Explorer.Tara |
 |
|
|
mchry99
Starting Member
6 Posts |
Posted - 2005-05-03 : 03:55:05
|
| Thanks for your reply. If I am not going for a third party tool can I use Auditing feature to know the actives of the system. What u feel , which feature is good ‘SQL Profiler or auditing’;RegardsMathew |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-03 : 12:30:44
|
| Not sure what you mean by auditing. Do you mean you'd have the application write rows to a table that gives you this information?SQL Profiler should not be run at all times which is what you'd need to do if you wanted to track this sort of activity at all times. SQL Profiler should only be run when you know what you are after and only for a few hours at a time.Tara |
|
|
|
mchry99
Starting Member
6 Posts |
Posted - 2005-05-04 : 01:03:34
|
| Dear I need to know the what are the UPDATE/INSERT statement issue in a some tables. I need which host executing these stmts, wht time,login name, throw which application this stmts executed… How can I take these information form the DBOtehr than SQL TracePls adviceMathew |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-04 : 12:37:43
|
| You would need to write triggers to do this, code your application so it does this, or purchase the third party product that I mentioned to read the tlog.Tara |
|
|
|
|
|
|
How can i trace the LOG file and Identify SQL stmt