I have a table where I have enabled change tracking without TRACK_COLUMNS_UPDATED. I know this because if I go through SSMS's Generate scripts, I get the line:
ALTER TABLE [dbo].[dt] ENABLE CHANGE_TRACKING WITH(TRACK_COLUMNS_UPDATED = OFF)
I want to enable TRACK_COLUMNS_UPDATED. If I run:
ALTER TABLE dt ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
I get error
Msg 4996, Level 16, State 1, Line 19
Change tracking is already enabled for table 'dt'.
Do I have to disable change_tracking first? If so, is this explicitly documented somewhere?