Home Forums SQL Server 2005 Administering Error Message: String or binary data would be truncated. RE: Error Message: String or binary data would be truncated.

  • Run a Trace, SQL Profiler, when you attempt to edit the data in SSMS, then my guess is you will see an update statement with your one character followed by spaces that are already in the column.

    In SSMS you can do a select all in the cell, and I'm betting there are spaces in there, delete and then enter the new characters.