Error 511

Troubleshooting SQL Server

Troubleshooting

Error 511

Severity Level 16
Message Text

Cannot create a row of size %d which is greater than the allowable maximum of %d.

Explanation

This error occurs when you attempt to insert a row that is larger than the defined maximum for that table. This error occurs if the row you attempt to insert into a table is too big to fit into a data page.

In Microsoft® SQL Server™, the maximum allowable size of a row in a table is 8060 bytes. A row cannot be split across data pages. A data page is 8 KB in size and consists of the data row and some internal data structures.

Action

Change the data being inserted so it does not exceed the maximum number of bytes (8060) that can be stored in a single row.

See Also

Adding Rows with INSERT

CREATE TABLE

INSERT

Maximum Capacity Specifications