How to set a time limit for remote queries (Enterprise Manager)
SQL Server 2000
To set a time limit for remote queries
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Connections tab.
- Under Remote server connections, in the Query time-out (sec, 0 = unlimited) box, type or select a value from 0 through 2147483647 to set the maximum number seconds that Microsoft® SQL Server™ will wait before timing out.
Note Remote server connections must be allowed before this value can be set.