1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “Microsoft SQL Server Management Studio No row was updated…String or binary data would be truncated…” – SQL Server Error Message

“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

Updated on August 1, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support