Error: 25002. The specified buffer size is not valid.

Hi,

When I try to update my big table (3000 rows and 51 columns), I faced the
SQLCE error: 25002. The specified buffer size is not valid.
I tryed to change allocation memory (Storage <---> Programs), but under any
conditions I can update 740 rows only.
I tryed to update DB with 500 rows portions, but it doesnt help.
In SQLCE.CHM help file, I found this:
***************************************************************************************************
During execution, Microsoft® SQL Server? 2000 Windows® CE Edition (SQL
Server CE) creates a temporary database that it uses for storing temporary
data such as:

a.. Pages that are part of an open transaction that no longer fits in the
SQL Server CE cache buffer.
b.. Interim result sets that are created during a query.
c.. Interim sort tables that are created when executing an ORDER BY
clause.
The temporary database is created when the SQL Server CE database engine
starts, and it is removed when the database engine is shut down in a
predictable manner. Abnormal termination of a SQL Server CE application
leaves temporary database files that must be manually removed. Unless a new
location for the temporary database has been assigned, these files can be
found in the \TEMP directory and have file names that begin with SQLCE, for
example, SQLCE334241234.tmp.

Growth of the Temporary Database
During execution, once its buffer cache is full, the SQL Server CE database
engine dynamically allocates resources to the temporary database. Large
databases can generate large amounts of temporary data during normal
execution. When the temporary database grows to the point that there is
insufficient storage space on the default storage device, the application
fails.

The following operations cause growth in the temporary database,
particularly when they are wrapped in a single transaction:

a.. UPDATE and DELETE statements.
b.. Explicit transactions.
c.. Sort operations: Sorting is required when indexes are created and also
when statements that include the ORDER BY or GROUP BY clause are executed.
*************************************************************************************************


So, how can I flush this buffer/temporary database?



Best regards,
Vadim Redkin

(Skype: ZiggZagg; ICQ: 96731334; Yahoo: redkinv@xxxxxxxxx; MSN:
redkinv@xxxxxxxxxxx)



.