• Another reason for being very careful with the MaxCmdsInTran parameter is that it can cause SQL Server to fail with error 9003. Basically, SQL Server gets its LSNs in a mess. You can recover from it with removing replication and putting it back on but only by deleting rows from msrepl_transactions and inserting what SQL Server "expects" to find there.