Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

ALTER TABLE HISTORY_RETENTION_PERIOD / Bug

Hi!

SQL Prompt will cause an error formatting this statement

ALTER TABLE dbo.test
SET (SYSTEM_VERSIONING = ON (HISTORY_RETENTION_PERIOD = 1 DAY));
GO

Thanks for fixing!

Torsten

Answers

  • Hi Torsten,

    I have replicated this, I will update you when I have heard from the development team.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Hi Torsten,

    This has been fixed in the latest version of SQL Prompt, please do let me know if you need any further assistance with this issue.
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
Sign In or Register to comment.