Solved

question about transactional replication

Posted on 2014-01-23
1
154 Views
Last Modified: 2014-02-06
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
0
Comment
Question by:bibi92
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39815179
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

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question