locked
UPDATETEXT and SQL Server Change tracking RRS feed

  • Pergunta

  • 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?

    quinta-feira, 23 de abril de 2015 14:50

Respostas

Todas as Respostas