[01004][0] [Microsoft][ODBC SQL Server Driver]String data, right truncation

This will happen when the size of the buffer created by application is less than the length of data retrieved from table.Mean s length of the column in the application specs is less than length of column in the database.
Practically in an enterprise this will happen only when someone plays with these lengths[either application end or database end].

So the approach is to narrow down the problem from View->Table->column.After this check whether the problem is with application specifications or with the database table specifications.