I am trying to execute
UPDATETEXT
command to update an image column. This column belongs to a table who has the change tracking active.
ALTER TABLE myTable ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON)
When I run the command the SQl Server 2008 R2 raise this error:
“UPDATETEXT is not allowed because the table is being tracked for change tracking.”
Is the updatetext command incompatible with change tracking mechanism? Is there a way that I can run this SQL command?