“Microsoft SQL Server Management Studio No row was updated…String or binary data would be truncated…” – SQL Server Error Message

Summary

This Error Message Article explains the SQL Server error message “No row was updated…String or binary data would be truncated” and details how to fix the underlying problem that caused it to appear.

Explanation

When inserting a row in SQL Management Studio, this message appears if data inserted does not conform to the data field definition (type, size, restrictions, etc.).

Solution

Reduce the size of the data or change the table structure to allow more data into the field.

Additional Comments

Error First Appeared: Windows 8 running SQL Management Studio 2008

Author


Was this article helpful?

Related Articles