Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Service Broker (2005)
 SQL Server Service Broker Updating Stored proc

Author  Topic 

hakansukar
Starting Member

2 Posts

Posted - 2014-05-28 : 15:36:29
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.
   

- Advertisement -