Your table design exceeds the maximum allowable number of bytes pr rows in sql server. If you assign the 1000 characters to all of your fields and try to insert a record you will get an error message from sql server like this
SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size xxxx which is greater than the allowable maximum of 8060. Because of this you need to redesign your table anyway and that might resolve the other problems that you have. Could you please explain why you are designing a table with 15 string field with length 1000??? -------------- Original message -------------- From: Stefan Osterburg <[EMAIL PROTECTED]> I have the problem with MS SQL, I have tried to change the field length to 999 - without success. The problem does not occur with only one or few fields of length 1000 but only if I have about 15 oder 16 of these fields in the table (I suppose if the record buffer becomes to big for a certain operation the kernel tries on it) Rudi Hansen wrote: > Change the field length to 999 chars, if you run Axapta on a Oracle SQL > server I know it has a problem with Char 1000 fields. > > I´m not sure if it is also a problem with MSSQL. > > ________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of Stefan Osterburg > Sent: 23. februar 2006 09:56 > To: [email protected] > Subject: [development-axapta] Axapta crashes when accessing a table with many > large fields > > > Hello all, > > I have created a table that contains a lot of large text fields. In my > case the table consists of 15 string fields with a length of 1000 each > and an ID field with a length of 10. > > Now Axapta crashes every time I try to perform certain operations on > this table for example: > - exporting data > - clicking into the id field that is used in another table > - performing certain selects (select count) > > Many other operations work without problems, for example using the table > browser on the table or joining the table in a form and displaying the data. > > Is there a known limitation for record/table sizes in Axapta? What can I > do to avoid the crashes apart from decreasing field sizes? > > Stefan > > > > > > > SPONSORED LINKS > Computer part > <http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w> > Programming languages > <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ> > Microsoft axapta > <http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg> > > Support exchange > <http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA> > > > ________________________________ > > YAHOO! GROUPS LINKS > > > * Visit your group "development-axapta > <http://groups.yahoo.com/group/development-axapta> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > ________________________________ > > > > > > > > > Yahoo! Groups Links > > > > > > SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
