Eight or More Clauses Causes Query Execution Error (121384)
The information in this article applies to:
- Microsoft Systems Management Server 1.0
- Microsoft Systems Management Server 1.2
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.
| Modification Type: | Minor | Last Reviewed: | 6/14/2005 |
|---|
| Keywords: | kbArtTypeINF kbbug kbnetwork KB121384 |
|---|
|