hi there,

I think you are talking about the activation procedure for the queue.

This is a procedure like any other store procedured. Just alter it as usual.

Get sure that your procedure is actual bound to the queue. Maybe you are changing another procedure but not the current activation procedure.

Use the ALTER QUEUE command to bind your procedure to the queue or check the table sys.service_queues, there you can find the current activation procedure.