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 |
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
 Posted - 2004-03-06 : 10:26:04
|
| Hi there,How can I decode the transaction log without buying an expensive piece of software?How do the people who write such software know how to decode the tr log?Cheers,I. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-03-06 : 10:44:00
|
| What do you want to decode?BTW Log Explorer isn't really all that expensive, considering the time and effort it undoubtedly took to create it in the first place. |
 |
|
|
X-Factor
Constraint Violating Yak Guru
392 Posts |
Posted - 2004-03-06 : 11:43:28
|
| I have some values in a database that I'm completely baffled as to how they happened to get like that.I wanted to look over the transaction and see how the records have changed so I can ultimately debug the application making the modifications.X. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-06 : 23:39:22
|
| DBCC LOG is what to use to get the information, but I've never been able to get it to work. I believe there are some examples in the forums here. I would strongly recommend using Log Explorer.Tara |
|
|
|
|
|
|
Reading Transaction