How to skip a transaction in SQL 2005/2008 Transactional Replication

Once in a while you may find the need to skip an indiviual transaction in SQL 2005/2008 Transactional Replication. For example, when Distribution Agent fails because of an error and the database integrity won’t be impacted by skipping that transactions.  For instructing the Distribution Agent to skip a transaction, SQL provides 2 very helpful stored procedures.  sp_helpsubscriptionerrors…

1

How to run TableDiff utility for ALL replicated (published) tables in SQL 2005 or SQL 2008

We recently need to find all the data which was different in 300 SQL Replicated tables on a pair of database.  To find the differences, we were planning on using the TableDiff utility included with SQL 2005.  TableDiff Utility http://msdn.microsoft.com/en-us/library/ms162843.aspx By default, the TableDiff creates a new *.SQL file for each table.  There is not…

1