What are the challenges you face when working across database platforms? Take the survey
Options

SQL Prompt introduces SCOPED CONFIGURATION errors

The statement:
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
Is reformatted as:
ALTER DATABASE [SCOPED] CONFIGURATION SET MAXDOP = 0;
which causes syntax errors.
Tagged:

Comments

  • Options
    James RJames R Posts: 104 Silver 4
    edited June 5, 2017 11:05AM
    Hi David,

    Thanks for noticing this! It's definitely a bug, I've found a fix here and will hopefully have it released in the next few days. I've logged this internally as SP-6361.

    Regards,
    James
    Software Engineer
    Redgate Software
Sign In or Register to comment.