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:
- Stop the Systems Management Server Site Component Manager and Systems Management Server Executive services on the Systems Management Server site server.
- Load the script using a SQL Server query tool, such as Query Analyzer or ISQL/W.
- Click the Systems Management Server database, and then execute the script.
- 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
