1

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.