Report Writer Does Not Return More than 10K Results
Article ID: 197238
Article Last Modified on 2/6/2000
APPLIES TO
- Microsoft Site Server 3.0 Standard Edition
This article was previously published under Q197238
SYMPTOMS
When you create a large return set (for example, for Direct Mailer) the
Report Writer stops when the results found reaches 10K. This occurs even
though a larger return set is specified.
CAUSE
This behavior is by design. The 10K row limit is required for performance
and possible product destabilization.
STATUS
Microsoft has confirmed this to be a problem in Site Server version 3.0
SP2.
WORKAROUND
To work around this problem, change the criteria of the report to result
in less than 10K.
Additional query words: SS3SP2FIX query truncate data
Keywords: kbbug kbfix kbsiteserver300sp2fix KB197238