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

Can't "Format SQL" when the query contains "SERVER ROLE"

rob_dalzellrob_dalzell Posts: 2
edited November 25, 2014 5:34AM in SQL Prompt
I can't see this reported anywhere else...

SQL Prompt (v6.4.0.678) doesn't seem to be able to "Format SQL" when the query contains any of:-

CREATE SERVER ROLE ...
ALTER SERVER ROLE ...
DROP SERVER ROLE ...

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    Hi Rob,

    Thanks for letting us know - I can recreate this here on 6.4.0.678.
    We're currently working on a new formatting system and I can confirm that this is working in that. Unfortunately it's not going to be ready for use for a few months so I'll have a look into seeing if we can backport the fix into the existing system to get you a fix sooner.

    Thanks,
    Aaron.
  • Options
    Aaron LAaron L Posts: 596 New member
    Hi Rob,

    My apologies, this may take a little while longer to fix so I've logged this in our bug tracking system as SP-5283. The fix is in a library that we're blocked from updating right now (hopefully to be resolved soon) but I'll let you know as soon as we have a new build with a fix in.

    Thanks,
    Aaron.
Sign In or Register to comment.