What are the challenges you face when working across database platforms? Take the survey
Options

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
Tagged:

Best Answer

Answers

Sign In or Register to comment.