MS SQL Server - Transaction Log details....columns?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Transaction Log details....columns?

2005-03-30, 7:03 pm

Win03StdSQL2ksp3

I think of the tlog as a table that list records of transactions.

1) If that is somewhat true, are their columns that would be user specific?

My problem is we were wanting to restore a DB and look at the transaction
log to see a play of events by someone.

2) Is a username in the row or just a spid or any thing user identifiable?

I have explored LogExplored 4.02 but without it installed prior to the
activity it will not give you the who. I played with ApexLog but not see a
user.

Any insight would be greatful.

C

Sponsored Links