[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

question about transactional replication

Posted on 2014-01-23
1
Medium Priority
?
164 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

650 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