This issue occurs because the field size of temporary tables is truncated when the tables are created. Then, rows are inserted that exceed the size of the field.
System.Data.SqlClient.SqlException: String or binary data would be truncated
December 17, 2007
Comments on: "System.Data.SqlClient.SqlException: String or binary data would be truncated" (4)
Check the schema column size and match it with the parameter size in the SP call. And use varchar field for the column if at all it is not having any specific data type constraints.
How do I fix this problem so that i’m able to register
just go to option design table by right click on it and change the size of column
showing one error “string or binary data would be truncated” in one system, but the same application working in another system properly.
Data base is “SQL2005″
Give me solution.