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

ID: Q155231

The information in this article applies to:

Microsoft SQL Server version 6.5

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          : kbbug6.50 kbfix6.50.sp2 
Version           : Windows:6.5.201
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 1, 1999