Total rowsize for table exceeds the maximum number of bytes per row (8060).

[Former Member]

I am trying to Creat a UserDefined Field in Marketig document OPOR Table through the script. then the warning "Total rowsize for table exceeds the maximum number of bytes per row (8060). " is occuring ,and transcation rollback. how can i solve the problem.

[Former Member · Accepted solution]

Hi Pankaj,

It looks like you have exceeded the maximum number of bytes that can be stored in a record. This is not a Business One issue, but rather a SQL Server issue. Maybe try your search on a search engine like Google. I don't know if the maximum can be set bigger with some administrative tools, but I think it can't.

Hope it helps,

Adele

[Former Member]

You have three ways to deal with this:

1) make you user field smaller.

2) check all other UDF in that table, and if you find one that your not using, delte it.

3) Somebody told me that SQL Server 2005 will not have this problem. Maybe you can migrate.

Best regards

Harold Gómez V.