Symptoms
When you try to store string or binary data that exceeds the target column size in Microsoft SQL Server, you receive the following error message:
Msg 8152, Level 16, State 6, Procedure ProcedureName, Line Linenumber
String or binary data would be truncated.
This SQL Server update introduces an optional message that contains the following additional context information.
Msg 2628, Level 16, State 6, Procedure ProcedureName, Line Linenumber
String or binary data would be truncated in table '%.*ls', column '%.*ls'.
Truncated value: '%.*ls'.
The new message ID is 2628. This message replaces message 8152 in any error output if trace flag 460 is enabled.
Resolution
This improvement is included in the following cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
References
Learn about the terminology Microsoft uses to describe software updates.
