CODEWITHSUNDEEP
sql-servertransactions
Fer
Fer

Reputation: 1992

how to determine that my table was updated in sql server

I have a table in sql server 2005. Yesterday an update was performed on the table and then updated back to the origional record.
Now i want to figure out what the updated values was. At least i want to learn if it was really updated or not.
Is there someway to determine what i want from the transaction logs?
Thanks.

Upvotes: 1

Views: 1570

Answers (1)

xanatos
xanatos

Reputation: 111850

There is an undocumented command:

DBCC log ( dbname, 0|1|2|3|4 )

where

0: minimum information (Default)

1: Returns info available using 0 + flags, tags and the log record length.

2: Returns info available using 1 + object, index, page ID and slot ID.

3: Maximum information about each operation.

4: Maximum information about each operation + hexadecimal dump of the current transaction log row

And read this: Looking for a SQL Transaction Log file viewer

Upvotes: 2

Related Questions