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 0, which allows an infinite wait.

The setting takes effect immediately (without a server stop and restart).

To set the remote login timeout option

    

See Also
RECONFIGURE sp_configure
Setting Configuration Options  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.