Microsoft SQL Server 2000
Best Practices
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.