Post reply

SQL Server times out when running a process from remote server

  • March 26, 2004 at 12:19 pm

    #65045

    Running a nightly process from a remote server , which updates quite few tables the user receives a time out message. No especifics on message. Just the generic time out message. I have set the time out query from remote to "0" and still coming back with the time out message. Other than setting the server to '0", is there any other way I can assure that the server does not time out?

    URGENT! Any help is GREATLY appreciated. Thank you

  • March 26, 2004 at 2:01 pm

    #500752

    Does you process access both remote and local server? If not you could create a job in the remote server to execute the query.

    Do you execute the process from an application? Is so, maybe you have a time out in the app.

     

  • March 26, 2004 at 2:09 pm

    #500754

    Yes, we do. It runs from the application, which is asp.net based. We modified the timwithin the application, but still times out. Thank you. Are you from Aregentina? I think I read a script from you once! A Any other suggestion? Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply