Using SQL Server 2005
I have two table which have the same datatype and datasize, same data's
When i execute my query, I got the result in one table, when i execute the another table i got this error as string or binary data would be truncated error, i checked the datatype size also. Before it was running, am getting this error from two days onwards.
I checked the datatype size also, i modified my datatype upto 256, still it showing error.
How to solve this issue.
You have to check everything is the same...
Edit: What was it of my list, out of interest please?
Perhaps it is a different field then the one you suspect.
If you are absolutely sure that there are no offending data values that are inserted into the table, then it must be a trigger. Check your triggers and you will find the offending data points there, which perhaps inserts into an completely unrelated table.
Unfortunately, the sql server error message has been the same since I know of the product (about 15 years). A better error message that shows at least the offended table name and column is among the feature requests for some time. No response from microsoft yet
K.
Things I would check:
If the fields size are the same, check for field sequence, i.e.
table1: Address,City,State,ZipCode
table2: Address,City,ZipCode,State
Inserting into table 1 from table two would cause the error.
Another possibility is the query might do some sort of concatenation
If the fields are all matched, then is there a trigger on the table that is also involving an additional table which has a column defined that is too short?
