Hey guys,
On one of our customers who uses 9.9.8 I keep getting an error in the eventviewer regrding an insert in this table. I put a profiler and I found out that some statements include 2 byte characters that are throw this error. What I mean is : the column is for ex. nvarchar(100), the parameter is delcared as nvarchar(60) but some how when a statement is sent with a string that is 60 characters on two bytes it will throw the truncation error . Anyways, I changed the table configuration to 120 on some comlumns that were 100 and to NVARCHAR(MAX) on some that where NVARCHAR(510) or so
The question is: Since the upgrade is not an option now, how critical is this table ? What is its purpose and is there a way to control the data flow that comes from dynamic web to it ?
Thanks
