При формировании скрипта на ALTER неправильно заполняется поле MAX_QUEUE_READERS
Ваш код:
Код: Выделить всё
ALTER QUEUE dbo.AsyncExecQueue WITH STATUS = ON,
RETENTION = OFF,
ACTIVATION (
STATUS = ON,
PROCEDURE_NAME = dbo.usp_AsyncExecActivated,
MAX_QUEUE_READERS = 1,
EXECUTE AS OWNER ),
POISON_MESSAGE_HANDLING (STATUS = ON)
GO
Код: Выделить всё
ALTER QUEUE [dbo].[AsyncExecQueue] WITH STATUS = ON ,
RETENTION = OFF ,
ACTIVATION (
STATUS = ON ,
PROCEDURE_NAME = [dbo].[usp_AsyncExecActivated] ,
MAX_QUEUE_READERS = 5 ,
EXECUTE AS OWNER ),
POISON_MESSAGE_HANDLING (STATUS = ON)
GO