I've this table with a field specified as type varchar(2500). But when data is saved to the table - they are truncated to size 500. I double checked the saving part and there is nothing in the stored procedure or in the code that can cause this. So I'm puzzled what I am missing.
Hi Chad and Lamprey - I believe I found the reason. That field length was increased to 2500 at some point and the stored procedures were updated to match that, but the dataset was not updated. As a result - the MaxLength property for that field in the dataset was still 500. So I updated the dataset. I haven't tested yet. If problem persists, I'll be back with more information.
In the meantime - thanks for your offers to help. Appreciate it, see you again.