SMS: Queries Fail to Execute when Alias is Specified and Collection Limiting is Used (235760)
The information in this article applies to:
- Microsoft Systems Management Server 2.0
This article was previously published under Q235760 SYMPTOMS
When executing a query in Systems Management Server 2.0, the query may fail if Collection Limiting is being used. The following error may also be reported:
The SMS Provider reported the following error:
SQL Err >> #107 Sev 16: The column 'SMS_R_System' does not match with a
table name or alias name used in the query.
SQL Err>> #10007 Sev 5: General SQL Server error: Check messages from
the SQL Server. 9null0
STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0. This problem has been corrected in the
latest U.S. service pack for Systems Management Server version 2.0. For information on obtaining the service pack, query on the
following word in the Microsoft Knowledge Base (without the spaces):
| Modification Type: | Minor | Last Reviewed: | 6/14/2005 |
|---|
| Keywords: | kbBug kbCollections kbfix kbQuery kbSecurity kbsmsAdmin kbsmsProvider kbWBEM KB235760 |
|---|
|