Question Re: sql server limitation for row data length in Additional Q&A https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737259#M110284 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It is due to multiple text column in particular table. Alternatively changing text column types to varchar(2000) will resolve this issue.</P><P></P><P></P><P>Regards</P><P></P><P>Jay</P></BODY></HTML> Wed, 09 Oct 2013 10:12:31 GMT Former Member 2013-10-09T10:12:31Z sql server limitation for row data length https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaq-p/9737257 <HTML><HEAD></HEAD><BODY><P>we are facing a challenge while creating UDF in SAP B1 - sql server limitation for row data length (8KB)</P><P>Has anybody faced such problem before and is there a solution / work around for this problem.</P><P>Please require an urgent help.</P><P></P><P>Thanks and Regards,</P><P>Ashutosh</P><P>7838432014</P></BODY></HTML> Fri, 20 Sep 2013 13:44:45 GMT https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaq-p/9737257 Former Member 2013-09-20T13:44:45Z Re: sql server limitation for row data length https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737258#M110283 <HTML><HEAD></HEAD><BODY><P>The common solutions include</P><P>1) storing some of the data in text/image columns</P><P>2) moving some of the columns to another table</P><P>3) splitting the data across multiple rows using a "sequence number" column to order them.</P></BODY></HTML> Tue, 24 Sep 2013 15:19:08 GMT https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737258#M110283 former_member188958 2013-09-24T15:19:08Z Re: sql server limitation for row data length https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737259#M110284 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It is due to multiple text column in particular table. Alternatively changing text column types to varchar(2000) will resolve this issue.</P><P></P><P></P><P>Regards</P><P></P><P>Jay</P></BODY></HTML> Wed, 09 Oct 2013 10:12:31 GMT https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737259#M110284 Former Member 2013-10-09T10:12:31Z Re: sql server limitation for row data length https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737260#M110285 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i face the same problem during creating UDF. Any update please share me!</P><P></P><P>my error:"<SPAN style="color: #222222; font-family: Calibri, sans-serif; font-size: 15px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px;">SQL Server limitation for row data length&nbsp; 'Payment Methods for Payment Wizard' (OPYM) (8060 bytes)&nbsp; [Message 131-405]"</SPAN></P><P></P><P>Many thanks,</P><P>Viet</P></BODY></HTML> Fri, 21 Mar 2014 15:48:02 GMT https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737260#M110285 Former Member 2014-03-21T15:48:02Z Re: sql server limitation for row data length https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737261#M110286 <HTML><HEAD></HEAD><BODY><P>Hi guy,</P><P></P><P>Have a look at my reply here: <A __default_attr="3374903" __jive_macro_name="thread" class="jive_macro_thread jive_macro" data-orig-content="Error at Creating UDF" href="https://community.sap.com/"></A></P><P></P><HR /><P>Best regards,</P><P><STRONG>Pedro Magueija</STRONG></P><P><BR /><A href="http://ch.linkedin.com/in/pedromagueija"><IMG alt="View Pedro Magueija's profile on LinkedIn" border="0" height="25" src="https://static.licdn.com/scds/common/u/img/webpromo/btn_viewmy_160x25.png" width="160" /></A></P></BODY></HTML> Thu, 26 Nov 2015 13:01:27 GMT https://community.sap.com/t5/additional-q-a/sql-server-limitation-for-row-data-length/qaa-p/9737261#M110286 pedro_magueija 2015-11-26T13:01:27Z