Results 1 to 2 of 2

Thread: Command TimeOut

  1. #1
    Join Date
    Jun 2004
    Location
    Treviso (Italy)
    Posts
    17

    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?

    Thanks :

  2. #2
    Join Date
    May 2006
    Posts
    16
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •