BUG: Select From a View Involving Outer Joins May Cause AV

ID: Q154035

The information in this article applies to:

Microsoft SQL Server version 6.5

SYMPTOMS

When you Select from a view that involves simple outer joins using ANSI syntax and a distinct clause, an "Exception Divide By Zero" error message appears.

WORKAROUND

To work around this problem, do not use a distinct clause in the Select statement.

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.

Additional query words: stack trace access violation sql

Keywords : kbnetwork SSrvGen
Version : 6.5
Platform : WINDOWS
Issue type :