New training course: Customizing SQL Prompt. Watch now.

Bug | ALTER DATABASE SET ENCRYPTION

Hi Redgate Team,

SQL Prompt fails when trying to format the two code lines

-- Suspend TDE encryption
ALTER DATABASE AdventureWorks2017 SET ENCRYPTION SUSPEND;
GO

ALTER DATABASE AdventureWorks2017 SET ENCRYPTION RESUME;
GO

Also there is no intellisense available for both commands.

Thanks for fixing!

Torsten

Answers

  • Hi Torsten,

    Thank you for your post. I have escalated this issue to the development team. I will let you know as soon as there is an update.

    Regards,
    Sujay
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
  • Hi Torsten,

    The development team has investigated this issue. Unfortunately, it appears to be an issue with the parser provided by Microsoft, which SQL Prompt depends on to do formatting actions.
    The development team has raised this with Microsoft, but it is unlikely that there will be a fix for this in the near future.

    Regards,
    Sujay
    Product Support Engineer | Redgate Software

    Have you visited our 
    Help Center?
Sign In or Register to comment.