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

torsten.strauss

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!

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

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

torsten.strauss

Thank you for considering this a potential bug!

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.