FIX: Multiple "LEFT OUTER JOIN" in FROM Clause May Cause Error

• Microsoft SQL Server version 6.5

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) 

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          : kbbug6.50 kbfix6.50.sp1 
Version           : 6.5
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: March 31, 1999