Home » sql server error msg 8152 level 16 state 14

sql server error msg 8152 level 16 state 14

sql server DBA 999

SQL Server Error : 8152, Severity: 16. String or binary data would be truncated

SQL Server Error : 8152 Details

SQL Server Error: 8152 Severity: 16 Event Logged or not: No Description: String or binary data would be truncated. Severity 16 Description: Indicates general errors that can be corrected by the user.

sql server error code 8152 or sql server error msg 8152 level 16 state 14

Explanation

At runtime, while inserting the data from DB2 table into SQL Server table, receiving the error “ERRORCODE: 8152 Error Message: [SQLServer JDBC Driver][SQLServer]String or binary data would be truncated”.

This error is usually encountered when inserting a record in a table where one of the columns is a VARCHAR or CHAR data type and the length of the value being inserted

Read the rest