3

I need to get the primary key(s) of an updated row from SQL Server transaction logs obtained via fn_dblog. As I can see, when the Operation is either LOP_MODIFY_ROW or LOP_MODIFY_COLUMNS, the [RowLog Contents 2] has the primary key. But it also has some additional data.

I have tried seeing different table structures, and I can see that some octets actually represent the primary key.

Can anyone explain the binary format of data in [RowLog Contents 2] for update transactions?

Dale K
  • 25,246
  • 15
  • 42
  • 71
Babu James
  • 2,740
  • 4
  • 33
  • 50

0 Answers0