Msg 8152, Level 16, State 2 [duplicate]

Question

This question already has an answer here:

• Getting error “String or binary data would be truncated” even for 'text' data type 1 answer

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.

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

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.