Please note that the following steps apply to version 8.2.1 and below only.
1. Execute the following steps in the database using a suitable query tool, e.g. SQL Management Studio:
Stop all DBQueue Processor components.
exec QBM_PWatchDogPrepare 1
go
exec QBM_PDBQueuePrepare 1
go
2. Check whether other database sessions are active:
select *
from sys.sysprocesses p
where dbid = DB_ID()
and spid <> @@SPID
If there are still sessions active, they must be closed first.
3. Create a new ServiceBroker ID and enable message delivery:
alter database <database name> set NEW_BROKER
go
alter database <database name> set enable_broker
go
Initializing the DBQueue Processor.
exec QBM_PDBQueuePrepare 0,1
go
exec QBM_PWatchDogPrepare
go
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center