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