• BOL recommends that you don't use UPDATE with NTEXT since the field only holds a pointer to "out of row" data.