FIX: Multiple "LEFT OUTER JOIN" in FROM Clause May Cause Error
Article ID: 153455
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q153455
BUG NT#: 15565 (6.50)
SYMPTOMS
Multiple LEFT OUTER JOIN tables in the FROM clause of a SELECT query may
cause SQL Server error 803. For example, the following query:
select authors.au_id
from
(((( authors
left outer join titleauthor on authors.au_id=titleauthor.au_id)
left outer join titles on titleauthor.title_id=titles.title_id)
left outer join authors a1 on a1.au_id=titleauthor.au_id)
left outer join roysched on titles.title_id=roysched.title_id)
where (roysched.royalty = 20)
will cause the following SQL Server error:
Msg 803, Level 20, State 2
Unable to place buffer 0x0 holding logical page 424 in sdes for
object 'titleauthor' - either there is no room in sdes or buffer
already in requested slot.
The SQL Server is terminating this process.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 1 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
Additional query words: ANSI
Keywords: kbbug kbfix KB153455