Microsoft KB Archive/235760

= SMS: Queries Fail to Execute when Alias is Specified and Collection Limiting is Used =

Article ID: 235760

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



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):

S E R V P A C K

Additional query words: prodsms

Keywords: kbbug kbcollections kbfix kbquery kbsecurity kbsmsadmin kbsmsprovider kbwbem KB235760

-

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

© Microsoft Corporation. All rights reserved.