skip a transaction in SQL 2005/2008 Transactional Replication

• Sharon Kumar

  Ten Centuries

  Points: 1193

  More actions

  August 30, 2011 at 7:35 am

  #247213

  hi all,,

  I was skip a transaction in Transactional Replication. I followed these to skip a transactions which is mentioned in the msdn site.

  http://blogs.msdn.com/b/chrissk/archive/2009/09/08/how-to-skip-a-transaction-in-sql-2005-2008-transactional-replication.aspx?CommentPosted=true#commentmessage

  After a skipping a transaction successfully & my replication is also working fine.

  But there are few transactions which are waiting to be applied.

  After Checking more details on undistributed commands, I found these are related the transactions which are skipped previously.

  what will happen after skipping transactions, those will a in undistributed transactions history,

  is there any thing else to delete those records ????

  Please help me

  THanks

  Ravi

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 28, 2011 at 7:24 am

  #1387749

  Were you able to solve this?

  M&M