You need to modify an existing service. You want to use a new queue and move the existing messages from the old queue to the new one. How can you accomplish that?

You need to modify an existing service. You want to use a new queue and move the existing messages from the old queue to the new one. How can you accomplish that?

You need to modify an existing service. You want to use a new queue and move the existing messages from the old queue to the new one. How can you accomplish that?


Answer: – Use the ALTER SERVICE statement and the ON QUEUE option.

(The ALTER SERVICE statement with the ON QUEUE option allows you to specify a new queue and move existing messages.)