Microsoft KB Archive/121384

= Eight or More Clauses Causes Query Execution Error =

Article ID: 121384

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 1.0 Standard Edition
 * Microsoft Systems Management Server 1.2 Standard Edition

-



This article was previously published under Q121384





SYMPTOMS
In Systems Management Server version 1.0, when you attempt to run a query consisting of eight or more clauses, the following error message appears in the Query Results dialog box:

Query Execution Error

In Systems Management Server version 1.2, the following error message may appear:

The specified query is too complex. This query exceeds SQL Server's 8 table limit. You might be to simplify this query by removing AND clauses.



CAUSE
This problem occurs because of the 16-table limit from SQL Server. Querying eight or more clauses calls eight references to the particular table as well as eight instances of the machine data table, thus reaching the 16- table limit.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Systems Management Server version 1.0.

This problem was corrected in Systems Management Server version 1.1.

Microsoft has confirmed this to be a problem in Microsoft Systems Management Server version 1.2.

Additional query words: sms prodsms

Keywords: kbarttypeinf kbbug kbnetwork KB121384

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.