CREATE QUEUE [dbo].[Applicati
Support the POISONMESSAGEHANDLING argument for service broker queues.
/****** Object: ServiceQueue [dbo].[ApplicationLogSendingQueue] Script Date: 03/15/2012 11:34:56 ******/
CREATE QUEUE [dbo].[ApplicationLogSendingQueue]
WITH
STATUS = ON ,
RETENTION = OFF ,
POISONMESSAGEHANDLING (STATUS = OFF) ON [PRIMARY]
GO
5
votes
Michael Connelly
shared this idea
The latest release of SQL Compare contains support for this syntax.