Export (0) Print
Expand All
Expand Minimize

How to: Set a Time Limit for Remote Queries (SQL Server Management Studio)

Use the remote query timeout option to specify how long, in seconds, a remote operation can take before Microsoft SQL Server times out. The default is 600, which allows a 10-minute wait.

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Connections node.

  3. Under Remote server connections, in the Remote query timeout box, type or select a value from 0 through 2,147,483,647 to set the maximum number seconds for SQL Server to wait before timing out.

    ms189040.note(en-US,SQL.90).gifNote:
    Remote server connections must be allowed before this value can be set.

Community Additions

ADD
Show:
© 2014 Microsoft