BUG: Many WRITETEXT Calls Causes DB-Library Error 10005

• Microsoft SQL Server version 6.5

SYMPTOMS

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.

WORKAROUND

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.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Process command commands st proc stproc db lib dblib

Keywords          : SSrvDB_Lib SSrvStProc SSrvTran_SQL kbbug6.50 
Version           : WINNT:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: April 16, 1999