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 |
|
hi_naroor
Starting Member
4 Posts |
 Posted - 2005-08-29 : 14:05:34
|
| Hi friends .I would like to read the transaction log file of a SQL server database .I tried DBCC LOG but its giving out opcodes and stuffs difficult to understand.Can i get a clear report saying that a varchar field containing 'DOG' was updated to 'CAT' with other details of that operation if i have performed that through the query analyzer.Please pass the comments,Bye,Naroor Rathish. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 14:07:04
|
| You'll need to purchase a third party tool to read the transaction log. One such tool is Lumigent's Log Explorer.Tara |
 |
|
|
hi_naroor
Starting Member
4 Posts |
Posted - 2005-08-30 : 01:01:58
|
| hi tara , can't we get with out using a third party tool .I jus want to see the word 'dog' in the result set .Is it posssible using fn_dblog()??waiting for your reply,Naroor Rathish. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-30 : 12:21:59
|
| I have never heard of fn_dblog(). I am not aware of any other way to read the transaction log. If you had SQL Profiler running when the update was made, then you'd see the query in that trace.Tara |
|
|
|
kiljab
Starting Member
1 Post |
Posted - 2005-09-03 : 14:19:14
|
| Hi Tduggand and Kara, i was recently testing Lumigent and APexSQL log with the same purposse of auditing changes in our databases. But i still looking for a third-party tool that fit our needs since Lumigent and ApexSql Log only are able to look for select, update, insert or delete statement but not for a Stored procedure execution. I still feel that it can be done with only using query analizer. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-03 : 14:22:14
|
| SQL Server's Profiler tool will let you monitor stored procedure execution via a trace. Anything that would let you track a SELECT statement can track a stored procedure being executed or created. |
|
|
|
|
|
|
Reading Transaction Log files