Thnak you very much it was very helpfull. I fixed it by improving my query. I cleaned up table therfore speed up the query it self.

THANK YOU

If it is not getting a time out error between 35-45 sec. If it is getting an error it takes 45-50 sec until the error message appears.

Greg

In QA it takes between 35 and 50 seconds to run and another query about 5 sec to run

Thanks

Greg

In my code i have time out setting:

m_cds.c.CommandTimeout = 216000;

Do you know what is the maximum number i can put there?

Thanks a lot.

Greg

I have tryied to increase the the timeout settings in the config file and it does not help. It is interesting when we are not running any complex batches on...