updating long text in SQL server

[Laura K]

Hi I upgraded from Access to SQL server and now I have a problem.

With access and the memo field there was no problem when my client updated
from a webform to a specific table.

Now that I have upgraded the client tells me that she is having intermittent
problems updating large amounts of text. When she updates small amounts
there is no problem. When she updates large amounts into several fields at
the same time she gets an error 500 approx every third time she enters the
info. She is updating from a web page.

Any suggestions?

Laura K

 

[Daran Johnson]

The simplest solution is to make the Access memo columns into SQL Server
text columns.

Since you did not post the DDL I am assuming that the memo columns have been
converted into varchar columns in SQL Server.

The problem the client is experiencing is an error in creating a row larger
then SQL Server will allow. When the tables were created you would have
gotten an error message to the effect that the table would be created but
the row size is too large if all the varchar columns were to be expanded.

The text datatype in SQL Server is stored on a separate data page then the
rest of the row. There is a pointer to the data from the row page. That is
why the text column can be much larger then a varchar column.

-Daran