BUG: SELECT on Cross-Database Views Causes Error 702 (158418)

SYMPTOMS

If you query on views created on tables present in another database, you may receive error message 702. The text of the error message is:

Memory request for <nnnn> bytes exceeds the size of single page of
<nnnn> bytes.

WORKAROUND

To work around this problem, either run the query on the base table itself, or wrap the query inside a stored procedure and then run the stored procedure.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.0 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This error may occur if the query is run from the database in which the views reside, and the query contains many joins, UNIONs, ANDs, and several subqueries.

For example, suppose you have created two databases, DB1 and DB2. The tables are present in DB1, and the views are created in DB2 from the tables in DB1. The query you are using is complex, as described above. To prevent this error message from occurring, you can do any of the following:

Wrap the query inside a stored procedure.
Insert UNION clause into a temporary table and then perform the UION on the temporary table.
Remove one of the subqueries.
Remove several of the AND conditions.