ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;

torsten.strauss

Hi Redgate Team,

SQL Prompt will raise an error when formatting

ALTER SERVER CONFIGURATION SET MEMORY_OPTIMIZED TEMPDB_METADATA=ON;

GO

Thanks for fixing!

Torsten
MVP

ATurner

Hi Torsten

Could you confirm that the error your getting is the "Incorrect syntax near MEMORY_OPTIMIZED"?

torsten.strauss

Yes, that is the error I get as well!

ATurner

Hi Torsten 

If I look at this in SSMS 18.9.2 without SQL prompt installed intellisense it flags this as invalid SQL?

torsten.strauss

Hi!
Is there an update on this bug?
Thanks!

ATurner

Hi Torsten

When I look at this in SSMS 18.9.2 without SQL prompt installed intellisense it flags this as invalid SQL?