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

HISTORY_RETENTION_PERIOD / Bug

Hi redgate Team,

the following statement will cause an error from SQL Prompt and HISTORY_RETENTION_PERIOD will not suggested.

CREATE TABLE test
(
    col1 int NOT NULL PRIMARY KEY
  , col2 varchar(100) NULL
  , valid_from datetime2 GENERATED ALWAYS AS ROW START
  , valid_to datetime2 GENERATED ALWAYS AS ROW END
  , PERIOD FOR SYSTEM_TIME(valid_from, valid_to)
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = history.test, HISTORY_RETENTION_PERIOD = 1 DAY));
GO

Would be good to see a fix - thanks!

Torsten

Answers

  • Eddie DEddie D Posts: 1,715 Rose Gold 5
    Hi, thank you for your forum post.

    I will run this past my colleagues in the development team and update when I receive their reply.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Eddie DEddie D Posts: 1,715 Rose Gold 5
    Hi, thank you for your patience.  I have added the details of this forum post to bug Report SP-7596.  I will update this forum post, when a bug fix version becomes available.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Eddie DEddie D Posts: 1,715 Rose Gold 5
    Hi, thank you for your patience.

    SQL Prompt V9.5.4.9799 was released a little earlier today which includes a fix for the bug reported in SP-7596.  To upgrade use the 'Check for Updates' option in the SQL Prompt menu -> Help or click the install link in the pop-up reminder that appears when you open SSMS (or Visual Studio).

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.