Microsoft KB Archive/181923

= BUG: SELECT with Many Columns Causes Handled Access Violation in Optimizer =

Article ID: 181923

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q181923



BUG #: 17839 (sqlbug_65)



SYMPTOMS
A SELECT statement that contains too many columns can cause a handled access violation error in the optimizer which returns

DB-Library Process Dead - Connection Broken to a DB-Library client

and EXCEPTION_INT_DIVIDE_BY_ZERO is recorded in the SQL Server error log.



WORKAROUND
Remove enough columns from the SELECT to allow the query to run.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbbug kbpending KB181923

-

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

© Microsoft Corporation. All rights reserved.