SET TEMPORAL_HISTORY_RETENTION ON

torsten.strauss · April 26, 2019 9:06AM

Hi Redgate Team,

It seems that there is not SQL Prompt support for

-- Enbable retention policy for a temporal tables
ALTER DATABASE AdventureWorks2017 SET TEMPORAL_HISTORY_RETENTION ON;
GO

TEMPORAL_HISTORY_RETENTION will not be suggested...

Would be great if you can add this- thanks!

Torsten

Dan B · April 29, 2019 4:00PM

Hi Torsten,

I will pass this along to the developers and come back to you as soon as possible.

Dan B · May 22, 2019 2:54PM

Hi Torsen,

This has been resolved in the latest version of SQL Prompt, you can download this from here ftp://support.red-gate.com/patches/SQLPrompt/22May2019/SQLPrompt_9.5.4.9799.exe. Please do let me know if you need anything further.

Answers