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.

marked as duplicate by LowlyDBA, Mr.Brownstone, John aka hot2use, Andriy M, mustaccio Mar 12 '18 at 1:43

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


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.