Microsoft KB Archive/231230

= SMS: Canned Queries Do Not Complete =

Article ID: 231230

Article Last Modified on 10/25/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q231230



SYMPTOMS
When you execute a canned query, such as 'All Systems' and 'All Client Systems' that are included in Systems Management Server 2.0, the query may fail to complete.



CAUSE
This issue can occur because these queries create very large temporary tables in the tempdb database. If the table runs out of space, the queries do not complete.



RESOLUTION
To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

236325 How to Obtain the Latest Systems Management Server 2.0 Service Pack



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0 This problem was first corrected in Systems Management Server version 2.0 Service Pack 2..



MORE INFORMATION
This hotfix can be used for both Systems Management Server 2.0 and Service Pack 1 sites. To install the hotfix, follow these steps:
 * 1) Stop the Systems Management Server Site Component Manager and Systems Management Server Executive services on the Systems Management Server site server.
 * 2) Load the script using a SQL Server query tool, such as Query Analyzer or ISQL/W.
 * 3) Click the Systems Management Server database, and then execute the script.
 * 4) Restart the Systems Management Server Site Component Manager and the SMS Executive services.

The script changes the following queries.

SMS001 All Systems

SMS006 All Systems with Hardware Inventory Collected

SMS007 All Systems with Microsoft Word 97

SMS026 All Systems with Specified Software Product Name and Version

SMS027 All Systems with Specified Software File Name and File Size

SMS028 All Client Systems

SMS029 All Non-Client Systems

NOTE: The script updates only the queries documented at the end of this article. Not all of the queries are updated.

Additional query words: prodsms

Keywords: kbqfe kbhotfixserver kbbug kbfix kbquery kbsms200sp2fix KB231230

-

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

© Microsoft Corporation. All rights reserved.