SQL Server error 511
SQL Server raises error 511 at severity 16, which marks a problem with the query or data that you can correct.
Cannot create a row of size %d which is greater than the allowable maximum row size of %d.
| Msg | 511 |
|---|---|
| Name | ROW_TOOBIG |
| Severity | 16 |
| Group | 0–999 |
What it means
The operation you have tried has exceeded the maximum size of a row. Usually, the maximum size of a row is 8,060 bytes. Some storage formats contain overhead that can reduce the row size that is available for data. For example, when you use sparse columns, the maximum size of a row is 8,018 bytes. Some operations that add or remove rows and some operations that change the data type of a column require the row to be rewritten on the data page, and then the original row is removed. In these operations, the effective limit to the size of the row is half the maximum limit. This is because the original row and the modified row must both be contained on the data page for a short period.