<div>
Where are you updating from ?<br />
<br />
Doesnt sound like a SQL Server problem as such. As Scott says, even 4000 characters is a doddle for NVARCHAR(MAX)<br />
<br />
must be procedural
</div>


Where are you updating from ?

Doesnt sound like a SQL Server problem as such. As Scott says, even 4000 characters is a doddle for NVARCHAR(MAX)

must be procedural

<div>
We &nbsp;found out the problem, was related with an Update trigger, with the wrong size.<br />
<br />
Thanks.
</div>


We  found out the problem, was related with an Update trigger, with the wrong size.

Thanks.

<div>
<div class="content wysiwyg-content">
We converted a SQL field from NText to NVarChar(Max), the conversion went smoothly, but recently when our programs do a record update, we began to receive the message &quot;String or binary data would be truncated.&quot; We checked the length of the new data for this field, and it is longer than the original values but it is way smaller than the 4,000 character maximum, we think that the problem is due to the fact that the field record is located at the end of a disk page boundary, and SQL can not extend the length of the field, our solution to this was delete the record and insert a new one with the new data. <br />
<br />
We are currently using MS-SQL 2016, the table was created in MS-SQL 2005.<br />
<br />
We are looking for a more smooth solution or a fix to this problem.
</div>
</div>


We converted a SQL field from NText to NVarChar(Max), the conversion went smoothly, but recently when our programs do a record update, we began to receive the message "String or binary data would be truncated." We checked the length of the new data for this field, and it is longer than the original values but it is way smaller than the 4,000 character maximum, we think that the problem is due to the fact that the field record is located at the end of a disk page boundary, and SQL can not extend the length of the field, our solution to this was delete the record and insert a new one with the new data. 

We are currently using MS-SQL 2016, the table was created in MS-SQL 2005.

We are looking for a more smooth solution or a fix to this problem.

String or binary data would be truncated.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.