title: SQL Replication error - row was not found at the Subscriber
body: <p>We are trying to setup replication on a SQL Server 2005 database. We have followed some instructions for the past year, and all has been fine. Recently, it started failing (Development environment, so every week we rebuild the database.. and apply replciation).</p>
  
  <p>We follow a set of steps, snap shot gets generated.. and applied to the replicated database. All fine. No errors.</p>
  
  <p>We then add a new row to the source database, and bang! Error.</p>
  
  <p><strong>Command attempted:
  if @@trancount > 0 rollback tran
  (Transaction sequence number: 0x000004BE00000558000100000000, Command ID: 1)
  Error messages:
  The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)</strong></p>
  
  <p>We're inserting a row, but it's complaining that the row isn't on the subscriber. That's right, though. We want it to replicate the insert to the subscriber...</p>
  
  <p>When we do a SELECT COUNT(*) on both the source and the destination, the row count is the same, until we do the INSERT, at which point, the source incriments, but the destination remains the same....</p>
  
  <p>Any ideas where we can start looking?</p>