I am developing a transactional replication plan.  I have one table
that most of the time I do not want to replicate deletions.  There is
an exception to this rule.  If the status_id of another table is false,
then the deletion should be replicated.

I have been having difficulty trying to put this condition in place.  I
have tried modifying the sp_MSdel_dboTable stored procedure.  I have
removed the if @@rowcount check and replication errors with the
messages:

--  Error executing a batch of commands.  Retrying individual commands.

Eventually, it will fail with the message:  if @@trancount > 0 rollback
tran

Any ideas on how to get around this issue?

Publisher:  SQL 2000
Distributor:  On a separate server
Subscriber:  SQL 2005

Thanks for any help I can get.