remote login timeout Option
Use the remote login timeout option to specify the number of seconds to wait before returning from a failed remote login attempt. For example, if you are attempting to log in to a remote server and that server is down, remote login timeout ensures that you do not have to wait indefinitely before your computer ceases its attempts to log in.
remote login timeout affects connections to OLE DB providers made for heterogeneous queries. The default setting for remote login timeout is 20 seconds. A value of 0 allows for an infinite wait.
The setting takes effect immediately (without a server stop and restart).
To set the remote login timeout option
Transact-SQL