Microsoft KB Archive/147177

= FIX: Complex T-SQL Batch May Hang During Query Plan Generation =

Article ID: 147177

Article Last Modified on 3/26/1999

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition

-



This article was previously published under Q147177



BUG# NT: 13132 (6.0)



SYMPTOMS
The complex transact-SQL batch hangs when executed in SET NOEXEC ON mode. The transact-SQL query batch has two inserts with a co-related update statement. Execution with SET NOEXEC ON causes the connection to be stranded with CPU utilization at 100 percent. Execution with SET NOEXEC OFF causes the connection and locks to be stranded with CPU utilization at 100 percent.



WORKAROUND
Break the transact-SQL batch into smaller components. You can do this by adding "Go" between the transact-SQL statements.



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

Additional query words: sql6 batch tsql

Keywords: kbprogramming KB147177

-

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

© Microsoft Corporation. All rights reserved.