This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 469608 (SQL Server 8.0)
Microsoft distributes hotfixes for Microsoft SQL Server 2000 as one downloadable file. Because these fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 hotfix release.
When you run a query that references a derived table or a view that is defined by a query that contains a LEFT OUTER JOIN clause, the query execution plan may display an incorrect row count estimate for the filter condition in the query. This problem may occur if the filter condition in the query references a column that is involved in the LEFT OUTER JOIN condition in the derived table query or in the view definition query.
Note This is a regression in SQL Server 2000 Service Pack 3 (SP3).
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.