FIX: 100% CPU Spin Opening Cursor on a RECOMPILE proc.. (155231)
The information in this article 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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix KB155231 |
|---|
|