How to set a time limit for remote queries (Enterprise Manager)

To set a time limit for remote queries

1. Expand a server group.
2. Right-click a server; then click Properties.
3. Click the Connections tab.
4. Under Remote server connections in the Query time-out (sec) box, select a value from 0 through 2,147,483,647 to set the maximum number of time, in seconds, that Microsoft® SQL Server™ will wait for a remote query to be processed before timing out.

   The default value of 0 prevents SQL Server from timing out.

Note Remote server connections must be allowed before this value can be set.