AI OnAI Off
I think there is a misunderstanding somewhere. Indexed_String01 is only nvarchar(450). it's not possible to have index on columns that are combined > 900 chars
Yes, when you add that attribute it tells DDS to use the indexed column. I think the API truncates the values automatically. You should use the non indexed column (it's nvarchar(max)), it does not make senses to index a 4000+ length column anyway
Hi, we have a column Indexed_String01 in tblBigTable with a varchar(8000), but when we store a string, it gets cropped even though the string is less than 8000 characters. Any idea why this happens?