sql server limitation for row data length

[Former Member]

we are facing a challenge while creating UDF in SAP B1 - sql server limitation for row data length (8KB)

Has anybody faced such problem before and is there a solution / work around for this problem.

Please require an urgent help.

Thanks and Regards,

Ashutosh

7838432014

[pedro_magueija]

Hi guy,

Have a look at my reply here:

---

Best regards,

Pedro Magueija

[Former Member]

Hi

i face the same problem during creating UDF. Any update please share me!

my error:"SQL Server limitation for row data length  'Payment Methods for Payment Wizard' (OPYM) (8060 bytes)  [Message 131-405]"

Many thanks,

Viet

[Former Member]

Hi,

It is due to multiple text column in particular table. Alternatively changing text column types to varchar(2000) will resolve this issue.

Regards

Jay

[former_member188958]

The common solutions include

1) storing some of the data in text/image columns

2) moving some of the columns to another table

3) splitting the data across multiple rows using a "sequence number" column to order them.