If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Command TimeOut

Hi,

i've a ASP application builds SQL for a report component; report execution get an error about command timeout, since i can't set it (i pass only query and connection to this component) is there a default generic option (for the SqlServer instance) that permits to me to increase this value?

you need check your sql script: how long does it execute in query analyzer and how many records will return.
if the time is spending on join or you get a large number of records, you need use stored prcoedure to speed up.