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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Read Transaction Log

Author  Topic 

MichelleMA
Starting Member

32 Posts

Posted - 2007-12-17 : 10:11:48
Hi,
I am looking for a way to read a transaction log in an Excel format, does anyone know how I can do this? I have already looked at the dbcc log(mydb), and its not documented, doesnt give enough info. I am more looking for an open source/free tool or a way to do it in SQL Server.

Thanks much.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-17 : 10:13:13
Luminent Log Explorer?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-17 : 10:14:36
select * from ::fn_dblog(default, default)



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-17 : 10:17:46
Also see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57183



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

MichelleMA
Starting Member

32 Posts

Posted - 2007-12-19 : 22:51:37
Thank you.
Go to Top of Page
   

- Advertisement -