O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

remote login timeout

Type: Basic

Default value: 10

You use the remote login timeout option to specify the number of seconds to wait before returning from a failed attempt to log in to a remote server. 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.

This option 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 following is an example of this option:

exec sp_configure 'remote login timeout', 30goRECONFIGUREGo

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required