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.