Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Reading a Transaction Log
- Thread starter WDfog
- Start date
tlbroadbent
MIS
Use the dbcc log command.
It is undocumented and the output doesn't show the actual SQL statement. Note that as with most undocumented dbcc commands you need to do a dbcc traceon(3604) first to see the output.
dbcc traceon (3604)
go
dbcc log ('dbname',4) /* options are 1-4 */
GO
dbcc traceoff (3604)
go
You can purchase a third-party tool.
Logview from Log Analyzer from Terry Broadbent
"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
It is undocumented and the output doesn't show the actual SQL statement. Note that as with most undocumented dbcc commands you need to do a dbcc traceon(3604) first to see the output.
dbcc traceon (3604)
go
dbcc log ('dbname',4) /* options are 1-4 */
GO
dbcc traceoff (3604)
go
You can purchase a third-party tool.
Logview from Log Analyzer from Terry Broadbent
"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
You can also look at for Log Explorer.
Regards - Franco
Regards - Franco
- Status
Similar threads
- Locked
- Question