Friday, July 30, 2021

Error: String or binary data would be truncated

(Anhgolden's Blog) - Lỗi này sảy ra khi lưu dữ liệu trên CSDL (DB) vượt quá giới hạn của Cột.

The "String or binary data would be truncated" error indicates that the procedure is attempting to store something in the DBServerInfo table that is larger than the column allows. The two known reasons this can occur are:

1) SQL Server has at least one database whose name exceeds 25 characters in length.

2) The 'show advanced options' parameter is enabled in SQL Server and you are running the Enterprise edition of SQL Server.

No comments:

Post a Comment