ALTER TABLE HISTORY_RETENTION_PERIOD / Bug

torsten.strausstorsten.strauss Posts: 271 Silver 3
in SQL Prompt
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

Tagged:
· Share on Twitter

Answers

  • Dan BDan B Posts: 287 Gold 5
    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
    · Share on Twitter
  • Dan BDan B Posts: 287 Gold 5
    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
    · Share on Twitter
Sign In or Register to comment.