CDC records Updates as Insert and Delete

• gcresse

  SSCrazy

  Points: 2286

  More actions

  March 6, 2013 at 1:41 pm

  #271172

  I am experimenting with using CDC to perform auditing in one of our user databases. If I perform an INSERT or UPDATE statement in SQL Server Management Studio, the operations are recorded correctly as 2 (INSERT) and 3 (BEFORE UPDATE) and 4 (AFTER UPDATE) but when I use our VB.net application, which passes a table-valued parameter to a stored procedure which then performs an UPDATE statement, cdc records the operations as 1 (DELETE) and 2 (INSERT). Has anyone run into this before? How can I get the stored procedure execution to record the update correctly?

  Thanks.

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  August 8, 2013 at 8:10 am

  #1639789

  we are facing the same issue. Let us know the solution if you fixed it.