String or binary data would be truncated - Determining Which Field ?
Posted on 2009-07-02
During the import of a table with about 80 columns and 1 million rows, I've received the error that "String or binary data would be truncated" ... however, SQL 2005 doesn't tell you which column is being truncated.
Is there any way to determine this, perhaps more robust error message options, etc.? A setting somewhere in SQL that will give more details? Or an error log I'm not aware of that would tell me more information?
I know how to fix the error itself ... my question is about getting more information out of SQL as to what the exact error was.