September 2009 - Posts

• 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. Read More... Posted Tuesday, September 08, 2009 4:36 PM by chrissk | 0 Comments Filed under: skip invalid transaction replication LSN

• 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 Read More... Posted Wednesday, September 02, 2009 10:53 PM by chrissk | 0 Comments