I set "Key and Updateable Columns” in update property for a dw as i want to prevent changes written by on use to overwritten by other user already access the same row

table have many fields some of these of type text and nvarchar

now when i try to update this dw- error occurs

"The data types text and varchar are incompatible in the equal to operator."

i have read that this error can be solved by changing all text fields to be nvarchar(max) is this true( i did not try it yet as i must re select all columns in all dws)?

is there any other way to overcome this error

Best Regards

Ahmed