FIX: Correlated Subquery Nested 3+ Levels May Give Error 403

ID: Q148267


The information in this article applies to:

BUG# NT: 13721 (6.00)

SYMPTOMS

A correlated subquery nested to three levels or more may give the following error message:

Msg 403, Level 16, State 1
Invalid operator for datatype op: UNKNOWN TOKEN type: char


WORKAROUND

Split the query so that the nesting level is less than three.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 403 correlated subquery


Keywords          : kbprg SSrvProg kbbug6.00 kbfix6.00.sp3 
Version           : 6.0
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: March 24, 1999