Hi,
Running SQL Server 2017. We have an activated stored procedure (which is encrypted) attached to a service broker queue to process messages. Everything is working correctly.
Now, we want to modify the stored procedure which is used by the queue. As the stored procedure in question is encrypted we are unable to ALTER, we instead need to DROP then CREATE. In order to do this, what steps do we have to take? Is it as simple as turning the queue off, re-creating the procedure, then turning the queue back on while referencing the newly-created procedure in the WITH ACTIVATION clause?
Thanks!