8152 / 2628 🗃️ SQL

SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)

A value is longer than the column allows.

Seen on: SQL

Meaning

SQL Server 2019+ (Msg 2628) names the column and value; older versions (Msg 8152) don’t — enable trace flag 460 or compare lengths.

Common causes

  • Input longer than NVARCHAR(n)
  • Column too small for real data
  • Older SQL Server hiding the column name

⚡ Quick fix

  1. Validate lengths
  2. Widen the column
  3. On SQL Server 2016/2017 enable trace flag 460 to see details

Detailed fix by platform

SQL

  1. ALTER TABLE dbo.Visits ALTER COLUMN UserAgent NVARCHAR(512);

How to diagnose

  1. Column — Which one?
  2. Value — Length?

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.