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
