How can we help you today? How can we help you today?

CREATE USER [xyz] FOR EXTERNAL PROVIDER WITH OBJECT_ID = '12354-5c5b-4860-9f' failing

Hi Redgate Team,

SQL Prompt fails when formating the valid syntax 

CREATE USER [xyz] FOR EXTERNAL PROVIDER WITH OBJECT_ID = '12354-5c5b-4860-9f';
GO

Thank you for fixing!


torsten.strauss
0

Comments

4 comments

Sort by
  • Jon_Kirkwood
    Hi @torsten.strauss

    Thank you for reaching out on the Redgate forums - I have replicated the refactoring error using your code snippet. This has been escalated to our development team so they can investigate further. 

    I did see some Microsoft feature requests around OBJECT_ID and I couldn't find where they formally announced its release or updated documentation to include it. 
    https://github.com/MicrosoftDocs/sql-docs/issues/7167
    https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql?view=sql-server-2017

    Regardless the team shall investigate and I will post an update on this forum post as soon as I have more to share.
    Jon_Kirkwood
    0
  • Jon_Kirkwood
    Our development team have accepted this as a potential bug in formatting the CREATE USER command with OBJECT_ID

    This is now logged into their active backlog to be worked on. For your reference the internal bug ref  # is TBE-115

    I will endeavor to update this forum post with the patch release where this bug is resolved. 

    Alternatively you can monitor patch release notes here:
    https://documentation.red-gate.com/sp/release-notes-and-other-versions
    Jon_Kirkwood
    0
  • torsten.strauss
    Thank you for considering this a potential bug!
    torsten.strauss
    0
  • ATurner
    Hi Torsten

    Unfortunately, this is an issue with the Microsoft parser and there is no ETA on when Microsoft may change this. So it is out of our hands for now, but will add it when there is a change to their end.
    ATurner
    0

Add comment

Please sign in to leave a comment.