Knowledge Base

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

Article ID: 181923

Article Last Modified on 10/3/2003

APPLIES TO

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


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.