Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2013-03-19 : 16:53:24
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-20 : 10:52:25
|
| one way is to increase timeout at application end. Another way is to see if you could optimize procedure to get data much more quickly.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Stored Procedure Timeout Issue