Microsoft KB Archive/164442

= FIX: ODBC Clients Show as Sleeping but Command Is EXECUTE =

Article ID: 164442

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q164442



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: kbbug kbfix kbprogramming kbusage KB164442

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.