changing an activatin stored procedure

Hello,

After I changed the activation stored procedure of a queue, the old activation stored procedure keeps being launched by the service associated with the queue. I turned the queue off and on, but to no avail. I also checked the dynamic view sys.service_queues to make sure the proper stored procedure exists in the field activation_procedure. Do you have any idea about what might have gone wrong?

Thanks

Mugur,

Changing the associated procedure does not shut down any running instance of the previous procedure. So if an instance or the procedure is running it will continue to run until it will exit on its own. One common problem is a logic defect in the procedure that causes it to never exit, in this case you must shut it down forcibly (i.e. using KILL, see http://msdn2.microsoft.com/en-us/library/ms173730.aspx)

HTH,
~ Remus

|||Thanks a lot Remus.