The information in this article applies to:
BUG #: 15312 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:
WORKAROUNDTo 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. STATUSMicrosoft 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.
Additional query words: SQL60 SQL65 UNION
Keywords : kbnetwork SSrvTran_SQL kbbug6.50 kbbug6.00 |
Last Reviewed: April 3, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |