SQL Server Performance

Altering service broker stored procedures

Discussion in 'ALL SQL SERVER QUESTIONS' started by alvinzaman, May 28, 2014.

  1. alvinzaman New Member

    How can you update the service broker stored procedure. when i update the stored procedure the changes dont come into affect. i have tried to alter the queue, waited for all jobs to finish, but some how still the old stored procedure is running. is there any way i can force changes to the stored procedure.
    i have tried sql profiler tracing but that didnt show any changes.
    how can you update the service broker stored procedure. when i update the stored procedure the changes dont come into affect. i have tried to alter the queue, waited for all jobs to finish, but some how still the old stored procedure is running. is there any way i can force changes to the stored procedure.
    i have tried sql profiler tracing but that didnt show any changes.

    Note: the service broker stored procedures produce and read xmls.
  2. davidfarr Member

    Changing an activated stored procedure does not kill any running instance. Most likely your old code is still running in a loop and will continue to run until it exits the loop or you kill it.

    Use sp_helptext to verify that the ALTER PROCEDURE actually occurred.

Share This Page