BUG: Many WRITETEXT Calls Causes DB-Library Error 10005

After performing approximately 32,000 WRITETEXT or UPDATETEXT operations in a stored procedure, a DB-Library application will get DB-Library error 10005: "DBPROCESS is dead or not enabled." This problem does not occur with ODBC-based clients.

To work around this problem, do any one of the following;

• Avoid using large numbers of WRITETEXT statements in stored procedures.
• Run the WRITETEXT statements outside of the stored procedure in a batch.
• Add SELECT statements to return data from the stored procedure between large numbers of WRITETEXT statements.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.