HISTORY_RETENTION_PERIOD / Bug
torsten.strauss
Posts: 266 Silver 3
in SQL Prompt
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
(
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
Tagged:
Answers
I will run this past my colleagues in the development team and update when I receive their reply.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com