Transaction Log

[klaforce]

Hi, I don't know if this is the right forum or not, but here goes. I am looking for a way to view what is in the transaction log. I have searched google, but the only thing I have found is an application called Log Explorer. I do not want to pay for this application because this is really just a one time thing. Let me know if any of you have any ideas.




Keith

http://www.clemson.edu/~davidla

The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

 

[checkai]

This is what we use...you can get a free trial of it....

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[klaforce]

Yeah, I looked into the free trial. It says that will only allow you to work on the Northwind database, which will not help in this situation. Thanks for your reply however.


Keith

http://www.clemson.edu/~davidla

The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

 

[mrdenny]

We also have log explorer. What is the end result that you are looking for?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[checkai]

not sure if this will help...

http://www.databasejournal.com/features/mssql/article.php/1443371

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[klaforce]

Basically what happened is we have a forum system (FuseTalk) that we lost some data on. Over the weekend our server crashed, and I wanted to look and see if the times were close to determine if they matched. Thanks checkai, I also saw that article, however, I can not interpret the results. It only returned 12 records that looked like this:

000000c6:000000ec:0001 LOP_BEGIN_XACT LCX_NULL 0000:0000c67e <Binary> 84 00000000:00000000:0000 <Binary> 0 <Binary> ClearChangeBits


Thanks for all your replies.


Keith

http://www.clemson.edu/~davidla

The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

 

[klaforce]

For anyone searching google. I found this sweet program that did what I wanted. It is called APEX SQL Log. I am assuming it is like Log Explorer, except the trial let's you view your databases, rather than the Northwind and pubs. Thanks for all the replies.


Keith

http://www.clemson.edu/~davidla

The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

 

[checkai]

http://www.apexsql.com/

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."