Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 03:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2005 at 06:08 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.