Bug | ALTER DATABASE SET ENCRYPTION

torsten.strauss

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

Sujay

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

Sujay

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