SQLUSA
 

Microsoft SQL Server 2000

Best Practices

 

How to set linked server connection timeout?

 

Linked server connection timeout should be set to real high value like 50000 (secs) so that you don't get timeout inadvertantly.

Same for query timeout.

 

Best in the World in SQL Server Training
 
SQLUSA.com Home Page