I set up transactional replication on SQL 2K database. Some of the tables are replicated using store procedures while others are replicated using sql commands. Some of these tables also contains triggers. However, these triggers are coded with syntax "NOT FOR REPLICATION" All manipulation of data are done using ado transaction via the application. My problem is I get Error Executing a batch, Execution of individual commands succeeded. And then it just stops after retrying for many times. It causes my replication to slow down whenever that happens. Then when error occurs I have to manually starts it or skip the error. I am wondering what could cause sql to execute individual commands /executing batch AND HOW TO PREVENT/SOLVE this problem. Your thoughts and help will be much appreciated.