WAIT_AT_LOW_PRIORITY formatting

RickPuig

Looks like I can't get SQL Prompt to format a partition switch with the WAIT_AT_LOW_PRIORITY option on.

Command I'm running:

ALTER TABLE dbo.myCCI SWITCH PARTITION 1 TO dbo.myCCI_2 WITH (WAIT_AT_LOW_PRIORITY (MAX_DURATION = 2 MINUTES, ABORT_AFTER_WAIT = BLOCKERS));

(table names intentionally replaced for identifiable purposes)

This command runs fine when highlighted + F5'd, but SQL Prompt gives me:

"Incorrect syntax near (."

Not a big deal - it's just formatting after all - but is there a workaround or some way to let SQL Prompt know that this syntax is legal?

Sujay

Hi Rick,

Thank you for your post. I have escalated this issue to the development team and will let you know as soon as there is an update.

Regards,
Sujay

Sujay

Hi Rick,

The development team has investigated this error. Unfortunately, it appears to be an issue with the parser provided by Microsoft, which SQL Prompt depends on to do formatting actions.

It is unlikely that there will be a fix for this in the near future.

Regards,
Sujay