Bug / Create user

torsten.strauss

Hi Redgate Team,

SQL prompt adds a semicolon after the user name which makes the code invalid.
Latest SQL Prompt version is installed.

CREATE USER [P-98-METRICS-ADVISOR-SPN] FOR EXTERNAL PROVIDER

GO

CREATE USER [P-98-xyz-abc-SPN] ;FOR EXTERNAL PROVIDER

GO

Thanks for fixing!
Torsten

DanC

Hi @torsten.strauss

Thank you for raising this, I can confirm I've been able to reproduce this bug.

I'm going to pass this over to the developers and get their thoughts!

DanC

Hi @torsten.strauss

If you upgrade to the latest version of SQL Prompt, this issue is now fixed!