Pages

Wednesday, January 4, 2012

NTEXT and Truncation Errors on Delete

0 comments
A quick note to the MS SQL users here with a reminder to help you avoid a little gotcha. The NTEXT data type was deprecated in MSSQL 2005. So, if you've migrated a db up to SQL 2005 or 2008 and, if you try to delete records in a table with an NTEXT field from the data grid view, you'll get an error telling you that the data will be truncated, and the delete won't work. You gotta delete through a query.

Funny what you don't recall if you don't use it often.
Continue reading →

Labels