I have a pretty involved query that takes about 5 minutes to run in query analyzer. I'm not too upset with that performance based on what it does. The problem I'm having is that it doesn't finish when run in reporting services as a report. I've had issues when a lot of rows and columns are returned, but the query returns 400 rows.
Is there a timeout setting somewhere in reporting services that causes it to hang? Is it a known problem for long-running queries? I can log into QA as the user I use for the report connection and run it fine. No apparent permission issues. It just never finishes.
Thanks for any insight.
Is this the property you are looking for?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_ir_9gds.asp
And a whole article on it:
http://www.databasejournal.com/features/mssql/article.php/3488466
