I found at least one answer: 
Gain control of the debugger if necessary, by issuing a BREAK, and then choose "Detach Debugee" or enter a ".detach" command from the...

Thank you, guys....Very helpful. I'll post back after observations....

One update: Consider that MSSQL won't allow a "truncate table <synonym>"...You'll need a work-around stored proc.

I'm honored by everyone's responses...Thanks, superstars!

Jeff, some very good points...

I will weigh everyone's suggestions.

Thanks for your help, everyone!

Thanks for the replies, all...

Question: Is there no benefit of using synonyms over renaming the base tables themselves?

I'm 90% confident that the SPID was doing a rollback of the MS DTC transaction.

Normally, you'd see "rollback" as the status of the SPID that was doing the failed query....

The subscribers are mobile Windows CE devices...That sync at different times. I cannot run this proc on the devices....

I cannot risk a re-init...Are you sure about that statement?

Ah, this is a known bug. There's a hotfix for the OS:

http://support.microsoft.com/kb/2761129

-SSS

Thanks, guys!

Anyone have a problem using the current DNS entry (pointed to the DB server), and repointing it to the Listener?

-SSS

I'll try....I need to find 3 hours where I can destroy I/O run the query without affecting prod.

Nah, I full-scanned all of them...It made the cardinality error get a little bit worse.

There are 196 steps in the histogram...I wonder if getting that close to the limit is...

Our DB2/LUW DBAs laughed at our hours of consistency checks, thinking it was an artifact of MSSQL.

Unfortunately, vindication came early this year, when their entire data warehouse had to be...

Our 8 DBAs take turns, a week at a time. We have a mix of RDBMS species, so if we handle an after-hours call on a system we don't...

I need to solve this, so I may end up opening a case with MS...

So far, it appears that it isn't a *real* ID conflict:

1) Subsequent syncs work without giving...

Ben, have you had any luck resolving this?

I too see this. I'm upgrading from 2005, with four republishers. I'm trying new topologies: 6 Republishers, and No Republishers....