SMS: No Query Results Returned When SQL Tempdb Is Too Small (135850)
The information in this article applies to:
- Microsoft Systems Management Server 1.2
- Microsoft Systems Management Server 1.0
- Microsoft Systems Management Server 1.1
This article was previously published under Q135850 SYMPTOMS
If you run a query that requires more space than is allocated for tempdb,
no return is displayed and no errors are given.
By default, Systems Management Server sorts the query results before
displaying them. This sorting is done in tempdb.
WORKAROUND
To work around this problem, do either of the following: - If this problem exists for a single large query, try to refine the query so that the query result is smaller.
-or- - Increase the size of tempdb.
For more information on device size recommendations and free space requirements, see the MORE INFORMATION section of this article.
STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 1.0, 1.1, and 1.2.
Modification Type: | Minor | Last Reviewed: | 6/14/2005 |
---|
Keywords: | kbbug kbConfig kbDatabase kbnetwork KB135850 |
---|
|