How to "update" change_tracking setting to enable TRACK_COLUMNS_UPDATED
2
votes
1
answer
634
views
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?
Asked by George Menoutis
(447 rep)
Oct 17, 2019, 07:56 AM
Last activity: Jan 2, 2023, 02:48 PM
Last activity: Jan 2, 2023, 02:48 PM