String or binary data would be truncated.
-
When and why this kind of exception occurs ? If it occurs then why the SQL Server dont show the column name to which this exception belongs ?
-
When and why this kind of exception occurs ? If it occurs then why the SQL Server dont show the column name to which this exception belongs ?
Vijay G. Yadav wrote:
why the SQL Server dont show the column name to which this exception belongs
Because SQL server is a PITA with this error. I have yet to find a simple way to debug this error, rabbiting through all the text fields and checking the length is just irritating.
Never underestimate the power of human stupidity RAH
-
When and why this kind of exception occurs ? If it occurs then why the SQL Server dont show the column name to which this exception belongs ?
Vijay G. Yadav wrote:
why the SQL Server dont show the column name to which this exception belongs ?
Good question. There's a suggestion to fix this on Connect[^], which has been open since 2008. So far, Microsoft have not responded. :sigh:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Vijay G. Yadav wrote:
why the SQL Server dont show the column name to which this exception belongs
Because SQL server is a PITA with this error. I have yet to find a simple way to debug this error, rabbiting through all the text fields and checking the length is just irritating.
Never underestimate the power of human stupidity RAH
Ha Ha Ha .... Thank you ;P ;P ;P
-
Vijay G. Yadav wrote:
why the SQL Server dont show the column name to which this exception belongs ?
Good question. There's a suggestion to fix this on Connect[^], which has been open since 2008. So far, Microsoft have not responded. :sigh:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Thank you
