ack message not picked up by stored procs

Hi

I setup a message between 2 database on a local instance. The message is send to the target and the target did send a reply. However, the reply is not picked up by the initiator. I did a try but there was nothing telling me why it did not pick up the reply. there is nothing in the textdata of the brokerclassify event. I query the queue on the initiator, the message is there, but the stored proc attached to the queue is not doing anything it seems. What else can I check here,

thanks

P

If you're positive the reply is in the initiator's queue but activation does not kick in, I'd look at the following:
- activation is not turned on. Check the is_activation_enabled column of sys.service_queues. If is 0, ALTER QUEUE <queueName> WITH ACTIVATION (STATUS = ON);
- the procedure has a bug and it runs, but has no effects. Check in Profiler if the Broker:Activation (Strat/Stop) events are being traced.

HTH,
~ Remus