FIX: ODBC Clients Show as Sleeping but Command Is EXECUTE

ID: Q164442


The information in this article applies to:

BUG #: 16453 (6.5)

SYMPTOMS

When an ODBC client runs a stored procedure, and after the execution is complete, the Current Activity in SQL Enterprise Manager or the results of a sp_who query may show that the process' (spid) status is sleeping, but the command is EXECUTE instead of AWAITING COMMAND.


WORKAROUND

If the process is not blocked by another process, the query has been completed, and you can ignore the EXECUTE command.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.


MORE INFORMATION

This problem may also occur with DB-Library clients that use the stored procedure API calls (those with RPC in the function name).

Additional query words: sqlrpc dbrpc


Keywords          : kbprg kbusage SSrvDB_Lib SSrvEntMan SSrvProg SSrvStProc kbbug6.50 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 8, 1999