locked
Stored procedure execution Timeout RRS feed

  • Question

  • Hi,

    We are running stored procedure to upload data through linked server to application server. Problem is that when we run stored procedure after some time it TimeOut. It happens once a while. I want to prevent this timeout issue, is there any way?

    Thanks

    Tuesday, March 19, 2013 8:52 PM

Answers

  • Is the linked server a SQL Server?  The SQL Server linked server timeout is set at the REMOTE server in server parameter "Remote Query Timeout".  The default is 0 - unlimited, so someone would have had to change it.

    Tuesday, March 19, 2013 9:01 PM
  • Hi DBA_LEARNER,

    You can refer to the solutions on the following link to troubleshoot the issue:

    http://forums.asp.net/t/1509587.aspx/1


    Allen Li
    TechNet Community Support

    Thursday, March 21, 2013 7:10 AM

All replies