SQL Format throws error when code includes statistics updates with MAXDOP

Fadi

The following code raises an error when I try to run Format SQL

UPDATE STATISTICS #table WITH MAXDOP = 1;

 The error is:

Dan_J

Hi @Fadi

Thanks for reaching out to us regarding this.

I am also seeing the same error when attempting to format that code, I will raise this with our development team and come back to you as soon as I have an update for you.

Fadi

Dan_J said:

Hi @Fadi

Thanks for reaching out to us regarding this.

I am also seeing the same error when attempting to format that code, I will raise this with our development team and come back to you as soon as I have an update for you.

Thanks Dan. Looking forwards to the fix.


Fadi.

Dan_J

Hi there @Fadi

Just to advise that this is currently still with our development team. Again I will come back to you as soon as I have an update for you.

Jon_Kirkwood

Thank you for your patience whilst our development team investigated this error.

Unfortunately it is not something we are able to resolve as this error is being generated from the Microsoft SQL Parser and not code that we control.

 Apologies we are unable to bring better news at this point, however this may be resolved through an update via Microsoft which would then be picked up by SQL Prompt in a future release.

Fadi

Jon_Kirkwood said:

Thank you for your patience whilst our development team investigated this error.

Unfortunately it is not something we are able to resolve as this error is being generated from the Microsoft SQL Parser and not code that we control.

 Apologies we are unable to bring better news at this point, however this may be resolved through an update via Microsoft which would then be picked up by SQL Prompt in a future release.

Hello Jon,

Thanks for reaching back. 
Out of curiosity, is the MS SQL Parser functionality independent of the Parse command SSMS uses?