Can you post your exec xp_sendmail statement?

Thanks for the response...makes perfect sense.

Make sure the triggers were not somehow marked with the NOT FOR REPLICATION clause.

One thing that I've experianced at times (but not always) is that SQL Mail fails if the Exchange Server was restarted, while the SQL Agent was running.

I try...

I like using the GUID best, but if you cannot change your table to use a uniqueidentifier then another trick is to use an Instead Of trigger on the table...

Bruce,

I know that is it a requirement that you allow anonymous subscriptions to the SQL Server merge publication, but you still have an access list associated with the publication so...

Found out from Microsoft that this is a known issue with several sort-orders. Sounds like they will have a patch this week.

If anyone is running into this problem. ...