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

UDF Error

Posted on Dec 04, 2007 at 06:55 AM 11 Views

Hi,

I was creating UDF in the marketing documents (Title) as follows:-

Title is Deliverto ,

Description is Deliver To

Type is Alphanumeric

Length is 30

Structure is Regular

But when I press ADD Button i got the following message "Internal Error(1)occurred Message 131 -183,can someone tell me what will be a problem and if there is any solution on this?

Regards

Grayson

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 07:20 AM
    1

    Grayson,

    The error seems to be related to Row size in SQL Server.

    Are you using SQL 2000?

    Click on the link below and read the thread as it also related to the same error.

    Error in defining the User Defined Fields

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 08:32 AM
    0

    Grayson,

    Since you are getting the Max row size error, The option you are left with is to reduce the size of some of your other User fields if possible. (I think you cannot reduce the size of a field once created so you have to delete the User field and recreate a new one of a smaller length/size.) Also try avoiding Address Type and Text type fields as these tend to occupy a lot of space.

    Otherwise you will have to Upgrade to SQL 2005.

    Sorry, thats all I have to offer.

    Suda

    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.