Knowledge Base

FIX: 100% CPU Spin Opening Cursor on a RECOMPILE proc..

Article ID: 155231

Article Last Modified on 10/3/2003

APPLIES TO

This article was previously published under Q155231
BUG#: SQL 6.5 15804

SYMPTOMS

The SQL Server process can go into a 100 percent CPU spin when a DB-Library or ODBC application opens a server cursor which executes a procedure that was created using the WITH RECOMPILE option.

STATUS

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

WORKAROUND

To avoid the problem, you change the procedure so that it does not include the WITH RECOMPILE option.

Additional query words: prodsql trace 100%

Keywords: kbbug kbfix KB155231


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.