Sounds like a good way to get yet more of the dreaded:
String or binary data would be truncated.
error. MS, seriously, you can't tell us which column had the error?? Paradox 3.5 for DOS could!!
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!