February 28, 2011 at 7:55 am
Hi,
Can you Please tell me about skipping a transaction in sql server 2005.
In which scenario we actually using skip.
I found a sp regarding this
sp_setsubscriptionxactseqno
I also read the BOL but im not able to understand it
Please help me.
February 28, 2011 at 8:31 am
Do you not want a transaction NOT to be applied or is it causing errors? If it is causing errors then you can allow it to be skipped by changing the distribution agent profile to continue on data consistency errors. If you are looking to just remove that transaction then you have to delete it from msrepl_commands and msrepl_transactions. You can do that by using the xact_seqno in both tables. Query them first to make sure that you understand how to construct your delete statement. Both tables are in the distribution database.
I will caution you to be careful with the delete operation, as one always should be. 😉
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply