|
| Reporting Services & Tempdb Problem |
 |
Tue, 2 May 2006 10:31:37 +0000 |
I have a report use SP with Dynamic SQL.
When execute the report on a long period the Report crush saying the tempdb is
full:
An error has occurred during report processing. (rsProcessingAborted) Get Online
Help
Cannot read the next data row for the data set AmgatMES.
(rsErrorReadingNextDataRow) Get Online Help
Could not allocate space for object '(SYSTEM table id: -375803370)' in database
'TEMPDB' because the 'DEFAULT' filegroup is full.
When i use SP with no Dynamic sql it works grate
1) why it happen?
2)How can i resolve it?I want 2 use Dynamic SQL!!!
|
| Post Reply
|
|
|
|
|
|
|
|
|
|