Home » Microsoft SQL Server Error: 8152

Microsoft SQL Server Error: 8152

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

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated

Details of Error:

String or binary data would be truncated. The statement has been terminated.

This error message below occurs when part data is been truncated while loading a table.

Actual error message:

Msg 8152, Level 16, State 14, Line 8
String or binary data would be truncated.
The statement has been terminated.

Resolution:

Either Shortened the data which is being truncated or increase length of the column on the Table or use below statements at the top and bottom of sql insert statement which is suppress the error

SET ANSI_WARNINGS OFF;
-- Insert
Read the rest