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 |
|
toftof
Starting Member
2 Posts |
 Posted - 2004-08-12 : 05:38:50
|
| Hello,I know that all transactions are stored in a .LDF file.But when I open it like a text file I can't understand it.I' d like to know all the queries (select,update...) that were done.is there a tool that allows me to read query in a .LDF file ?is there an other file for that ?thanks christophe |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-08-12 : 08:11:44
|
You'll have to buy one of those log viewing tools. See :www.logpi.comwww.logexplorer.comoops! www.lumigent.comOS |
 |
|
|
rlahoty
Starting Member
11 Posts |
Posted - 2004-08-12 : 09:15:39
|
| It is not www.logexplorer.com but it is www.lumigent.com that has a product called log explorer. It is a nice tool. No selects are logged in Transaction Log. You can see update, insert, delete, truncate etc. in there. Also those updates like 'UPDATE table SET col1 = 1 WHERE col1 = 1' are not logged in the transaction log. |
|
|
|
|
|
|
transaction file