CANNOT OPEN UDF

[Former Member]

Hi all,

In the last days, it is impossible to open UDF Fields in a development database that I use.

The message that I get is "Incorrect Syntax Near 'Max' (AITM).

I get the message trying to open nvarchar fields on Items Object. On the other cases, sometimes I can open fields, sometimes I cannot.

For example, trying to open a numeric field I have no problem. On the other hand trying to open an Image field I confront the same issue.

Checking SQL Trace, there is a query running, when adding the field,

ALTER AITM Add (field_name) nvarchar(max),

which I think may cause the problem.

I run the query, also, both in SQL 2000 and SQL 2005 environment and I get the same error

Any ideas?

Thank you in advance

George

[former_member186095]

Hi,

I am afraid the query could be a source of error but it must be clear to us if the query is store procedure or not.

Rgds,

[Former Member]

Hi

The query is one of which are ran, when I try to open a UDF from SAP Interface.

It is not a query of mine.

What I have done is to check the traces on SQL Profiler, when making the action of adding a UDF on SAP. One of the queries ran was the one mentioned on my question (and the only one containing the value "max" which is contained on the error message). So, my presumption is that this is the problem.

I don't know if there is a way to open a UDF now or my database is in a way "corrupted"

Hope this was helpful,

Regards

Edited by: Rui Pereira on Apr 28, 2009 12:27 PM