We are in a similar position.  MS-SQL replication consistantly fails due to the design of our database which unfortunately I have inheritted.  Currently we cannot change the database structure in any...