The deferred transaction eventually resolved itself, also. Thanks ChrisM.

This is what I ended up discovering. In addition to replication, an older version of the master database had the procedure that builds these tables set to run on...

For anyone who might read this later:

When I did EXECUTE AS and ran as the user the queue runs as ('dbo') I found out I could not use Database Mail....

I think I'm closer to the source of the issue. When I try to run the activation procedure as the service broker user, I get this output:

(1 row(s) affected)

Msg...

I managed to process all of the messages in one of the queues manually without issue...but if I'd set Activation = ON it would have failed. It's very curious.

The second I set activation back on my Activation SP failed with a "Queue is currently disabled" error

EDIT: All of the transmission_queue messages for the queue I enabled were sent...

I set the status of a queue to ON and turned activation OFF and ran its activation SP manually. So far it seems to be processing perfectly fine. ...

Hm. Is there a way I could enable the queue to manually send a message without the activation procedure causing it to disable again instantly?

Thanks for all your help.

GilaMonster (3/13/2013)

---

Yeah, most people aren't convinced until something fails catastrophically. Make sure your backups are good.

Also, it isn't necessarily the physical drive. Could be the firmware, drives, switch, cache, any...

Migrating the...

Steve Jones - SSC Editor (3/12/2013)

---

Corruption in the clustered index is likely a call to Microsoft. This is the data, and so you can't rebuild.

If I had this, I'd try...

Actually it seems like the problem is still present. The SP that first indicated there was a corrupt index worked once after the drop/create and failed again after.

I do have one further question. If there had been corruption in the clustered index, would I have needed to do a restore?

DROP...