Sample Header Ad - 728x90

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