Knowledge Base |

# 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