Msg 13575 OR Msg 13542 error message while adding period columns

You may see following error message while trying to enable system-versioned temporal table and adding period columns for a table which contain data: 1st error message: Msg 13575, Level 16, State 0, Line 32 ADD PERIOD FOR SYSTEM_TIME failed because table ‘temporaltest.dbo.CUSTOMERINFO’ contains records where end of period is not equal to MAX datetime. 2nd… Read more