Microsoft KB Archive/155231

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

Article ID: 155231

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



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

-

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

© Microsoft Corporation. All rights reserved.