Report Model Timeout

When building a report model on a large set of data I constantly get a
timeouts before it complets building. I've changed the query timeout on the
data source to both 600 seconds (the max) and 0 seconds (which should be no
timeout) and I still get timeouts. I installed SP1 for SQL Server 2005
because it talked about something similiar to this issue but it didn't fix
this issue. I still get a timeout and the model is not built. Is there
anything else I can try and is this expected behavior?
Thanks.No one has timeouts when building models against large tables'
"Aaron" wrote:
> When building a report model on a large set of data I constantly get a
> timeouts before it complets building. I've changed the query timeout on the
> data source to both 600 seconds (the max) and 0 seconds (which should be no
> timeout) and I still get timeouts. I installed SP1 for SQL Server 2005
> because it talked about something similiar to this issue but it didn't fix
> this issue. I still get a timeout and the model is not built. Is there
> anything else I can try and is this expected behavior?
> Thanks.|||you need to give it more than 13 minutes, buddy
when you say.. large tables; you're talking about a few, maybe a dozen
tables; with like a million records?
give us some scope; ok?
-Aaron
Aaron wrote:
> No one has timeouts when building models against large tables'
> "Aaron" wrote:
> > When building a report model on a large set of data I constantly get a
> > timeouts before it complets building. I've changed the query timeout on the
> > data source to both 600 seconds (the max) and 0 seconds (which should be no
> > timeout) and I still get timeouts. I installed SP1 for SQL Server 2005
> > because it talked about something similiar to this issue but it didn't fix
> > this issue. I still get a timeout and the model is not built. Is there
> > anything else I can try and is this expected behavior?
> >
> > Thanks.sql