How can we help you today? How can we help you today?

Question about a syntax error

In SSMS, this statement runs and executes fine.  In VS 2017 and SQL Change Automation, I receive an error.  Can you explain what is going on?  Thank you!

ALTER TABLE dbo.[User]
SET (SYSTEM_VERSIONING = ON (HISTORY_RETENTION_PERIOD = 7 YEAR));
GO
Corinne
0

Comments

4 comments

Sort by
  • Diogo
    Can you please double check which Target platform your project is using as per this other question? https://forum.red-gate.com/discussion/83165/support-for-temporal-tables

    I think you might need to change to either SQL 2017 or one of the Microsoft Azule SQL Database.
    Diogo
    0
  • Corinne
    Yes my target platform is set to Microsoft Azure Database V12.
    Corinne
    0
  • Diogo
    I'm afraid I didn't get any error with the alter table script when I used Microsoft Azure Database V12. Are you using the latest version?
    Diogo
    0
  • Corinne
    You are correct, Diogo.  My dev/test/prod database are on Microsoft Azure Database V12 and do not complain.  My local db database is on SQL2016 so it does not understand that parameter.

    Corinne
    0

Add comment

Please sign in to leave a comment.