but its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit.

Question

Hi Experts,

I am facing this issue of
"but its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit."
in production enviornment. Previous developers decided to kepe the design in away to have 641 columns in this table. Moving columns and normalizin is alot more work and needs more time. But since this is a production job, I am looking for some workaround. I have 247 varchar columns and there are lots of columsn with varchar(n). Reading some posts online, is it okay to change some of the varch(n) to varchar(max). is there any other way to fix this issue wthout changing the table design. I would really appreciate any help.

Thanks,
Ro

Answer 1

Here is the exact error:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Cannot create a row of size 15829 which is greater than the allowable maximum row size of 8060.".

Answer 2

Hi @Rohit Kochar ,

Please refer to this document: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15#-objects
The main reason is that your table is not designed properly, and you can split it into several tables later.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Have you managed to fix this? I have run into a similar situation.