Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbadminsoft
Starting Member
2 Posts |
 Posted - 2009-05-29 : 09:19:38
|
| hello everybodyi want know how i can skip transaction applied for replicate in the publisher i know how i can skip the transaction duplicate for the message error cannot insert duplicate.the message error for the transaction duplicate no 2601;2627if you want skip transaction duplicate you must edit this in the agent profile.go to the session publication monitor and right click on the subscription and click on agent profile ,add new agent profile with any name and in the profile you can write the number error message for the duplicate in the -skiperrore look like this -skiperror 2601:2627and click ok .now you will not the message for duplicate appear again the agent will ignore the transaction duplicate applied in the publisherbut i want know how i can skip transaction delete the error message 20598 the error row not found and i don't want write the number of this message in the agent profile because this can make ignore the transaction update toojust i want know best way for skip the transaction deletethankskhaled |
|
|
|
|
|
how to skip transaction applied in the publisher