question about transactional replication

Hello,

Is it possible to update sp_msdel and sp_msup like :

Update :

Update the row and update the additionnal column dt_maj = getdate()

D:

Not delete the row, a logical delete :
       Update the column dt_delete = getdate() and the column delete=1

Thanks
bibi92Asked:
Who is Participating?
 
Ryan McCauleyData and Analytics ManagerCommented:
I wouldn't do this by updated the stored procedures. Rather, you could accomplish this by using a trigger on the destination tables - an AFTER trigger for the first statement (to update that column) and an INSTEAD OF trigger in the case of your second statement.

If you need help doing that, I can stub something out for you, but triggers are likely the best way to accomplish this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.