you can not do a delete with no log but you can stop them replicating.
Simply do the following out of hours.
Run the logreader
Run the distribution tasks to make sure replication has worked (This
must be run until successful)
Unsubscribe the subscribers from the table in question
Do the deletes on the table
Re-subscribe the table with a sync type of none
This would work ok but there can be no one else doing transactions on that
table otherwise they may be lost between the unsubscribe and the resubscribe
with no sync.
>I have a similar problem. I also want to delete some records from a table
>but I don't have a problem with the syslogs necessarily. This table is
>published and I don't want the delete to replicate to the subscribing
>servers. I can't truncate the table, I just want to delete records older
>than a specific date.
>Does anyone know how to do a "DELETE .... WITH NO_LOG" or equivalent?