Hi Max,

I would create another table with the same structure but ntext column instead of nvarchar and copy all the record into it. After that you can anylize data to see what causes the problem and act accordingly.

>
>Using sql2k.
>
>When I add a nvarchar column to a table, lenght exceed maximum lenght prompted,
>
>but it saved and opreation of inserting, deleting is OK.
>
>But, i can never modify the table with enterprice manager or query analyzer.
>
>The table is dead-lock, what a pain.
>