One other potential reason for this is if you have a default value setup for a column that exceeds the length of the column. It appears someone fat fingered a column that had a length of 5 but the default value exceeded the length of 5. This drove me nuts as I was trying to understand why it wasn't working on any insert, even if all i was inserting was a single column with an integer of 1. Because the default value on the table schema had that violating default value it messed it all up - which I guess brings us to the lesson learned - avoid having tables with default value's in the schema. :)

如果你使用的是SQL Server 2016-2017: 要修复此问题，请打开跟踪标志460

DBCC TRACEON(460, 1);
GO

确保你在以下情况下将其关闭:

DBCC TRACEOFF(460, 1);
GO

源

当您没有足够的权限时，也会发生这种情况

One other potential reason for this is if you have a default value setup for a column that exceeds the length of the column. It appears someone fat fingered a column that had a length of 5 but the default value exceeded the length of 5. This drove me nuts as I was trying to understand why it wasn't working on any insert, even if all i was inserting was a single column with an integer of 1. Because the default value on the table schema had that violating default value it messed it all up - which I guess brings us to the lesson learned - avoid having tables with default value's in the schema. :)

您需要发布源表和目标表的表定义，以便我们找出问题所在，但底线是源表中的一列比目标列大。这可能是您正在以一种您没有意识到的方式更改格式。要弄清楚这一点，您要使用的数据库模型也很重要。

我将添加另一个可能导致这个错误的原因，因为没有人提到过它，它可能会帮助一些未来的人(因为OP已经找到了他的答案)。如果要插入的表有触发器，则可能是触发器正在生成错误。我曾在更改表字段定义时看到过这种情况，但审计表没有更改。