New training course: Customizing SQL Prompt. Watch now.

WAIT_AT_LOW_PRIORITY formatting

RickPuigRickPuig Posts: 1 New member
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?
Tagged:

Answers

  • SujaySujay Posts: 31 Bronze 1
    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
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
  • 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
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
Sign In or Register to comment.