Have anyone experienced this?

String or binary data would be truncated

Raised during ALTER INDEX; even in CREATE TABLE. I'm not having this problem in other databases. I may have reconfigured something as this is only a test database.

enter image description here

All I am seeing in the internet is regarding length of strings inserted by INSERT statement exceeds in the length of defined data type.


1 Answer 1


Community wiki answer:

Check for triggers, and DDL triggers on the database.

The error message gives the name of what to look for: procedure DatabaseAudit line 47.


Not the answer you're looking for? Browse other questions tagged or ask your own question.