transaction log

[jpreed]

Does anyone know of the record composition of a transaction log record?

i.e. when you do a:

DBCC log ( dbname, 4 )

It will give you a record listing of the transactions currently in the log. What I need is a description of what each column contains and, if at all possible, a way to manually view the information stored in the hex field, 'Record Data'. More than likely, this information is the serialized version of the record changed during the transaction. I haven't been able to find any information on how to deserialize it either...

Thanks for any info.

Best regards,

Jeremy

[Sxooter]

What database is this? MSSQL server? You might wanna look for a db specific forum for such an issue, as it's not likely you'll find lots of folks with experience outside mysql, postgesql, firebirdsql, or oracle around here, in that order.

[jpreed]

My apologies. I should have specified that it is MS SQL 2000 server.

[Sxooter]

No apologies necessary, just that you might find your answer elsewhere faster. not a lot of MSSQL - PHP folks here. Especially ones who understand transactions and such.