Allow to use SQLCMD variables in SSDT for MAX_QUEUE_READERS
I would like to set different values for MAXQUEUEREADERS in production and development environments.
To do it I tried following SQL:
CREATE QUEUE Queue
WITH ACTIVATION (
PROCEDURE_NAME = ActivationProc,
MAX_QUEUE_READERS = $(WorkerPoolSize),
EXECUTE AS OWNER);
SSDT reports syntax error at $(WorkerPoolSize) during build.