Babu James
Reputation: 2843
Get primary key(s) from fn_dblog update transaction
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?
Upvotes: 3
Views: 286
Answers (0)
Related Questions
- Getting the primary key of an newly inserted row in SQL Server 2008
- SQL violation of Primary Key constraint on update
- how to update primary key value in sql?
- How to parse a primary key
- SQL Server 2008 : update the table with primary key
- How to get Primary Key on SQL Update?
- Retrieve mssql primary key from query?
- Return all primary keys affected by update query
- Determining the primary key from a SQL Server statement
- Primary keys in a logging database