Error on insert: "cannot create a row of size 8XXX which is greater than the allowable maximum row size 8060"

Version 1

    Details

    You may encounter an error when inserting or saving a record of any kind: "cannot create a row of size 8XXX which is greater than the allowable maximum row size 8060"


    Resolution

    This indicates that the actual text-storage size in SQL server is 8KB per-row. This is raw text size in Unicode type.  


    This ultimately means that you are inserting or adding substantially more text data than SQL Server can handle in the row (note: the key here is row -- You are not necessarily exceeding any particular column/field size, but rather the capacity of the entire row).

    This is a design-specific error. By default, HEAT contains no designs that exceed the 8kb row size limit. Since this is a SQL-generated error, a SQL trace during the attempted insert/update should reflect the offending data.  Further information can be found at: