Hi, We have a report which gets aborted due to tempDB space issues. The report stored procedure internally calls a SQLCLR stored procedure which in turn calls a windows service to convert RTF text to images. These images are clinical documents with a resolution of 200 dpi. Once the image conversion process completes the SQL stored procedure fetches the images along with other patient information. The stored procedure creates a lot of temporary tables, tables variables and unions. The report subscription works fine few of a times and aborts few times due to tempdb space issue. We also monitored the tempDB space during the report processing and it seems whatever memory is available at the start of the report is still available at the end of the report. This issue is creating a lot of problem at the production environment. Is there any solution which can solve this issue? It is very urgent. Please any help would be appreciated. Regards, Gayatri

http://technet.microsoft.com/en-us/library/cc966545.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hello, Follow the thread below. It will help you. http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/12cdc5fd-58c2-4706-940c-abb320f383e2