Post reply

finding exactly which rows got modified in sqlsrver 2008 replication

  • December 17, 2013 at 12:49 pm

    #302465

    how can i find out exactly which rows and what was changed in those rows in sqlserver 2008 replication on a subscriber?

    Replication monitor does not tell this , it only says how many rows were delivered.

    thanks

  • December 17, 2013 at 10:31 pm

    #1674275

    Not easily. It is the same question for a client modifying a row in SQL, how do you know what has changed?

    You would need to enable Change Tracking or Change Data Capture, or use profiler to capture the statements, or have triggers / auditing / custom code.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply