This afternoon, you modify a field in a table directly in SQL Server 2008 's Microsoft SQL Server Management Studio, either by deleting the characters or by adding the following error.
Many people on the web say that the table field definition length is less than the input data length, I am obviously not the problem, that is, using the test data to enter some single letters or numbers or to prompt the problem.
Workaround: (Microsoft recommends replacing the ntext field type with nvarchar (max) because its future version will no longer support ntext. After the ntext field is nvarchar (max), you can modify the contents of the field and empty the contents of the Error field. After saving, restore the field type to ntext., the content re-added from the background, the problem is resolved.
SQL Server2008 Error Source: Workarounds for. NET SqlClient data Provider