Purpose

The purpose of this article is to teach you the process of setting up a time limit for remote queries in Microsoft SQL Server 2000.

To Set a Time Limit for Remote Queries

Remote query timeout option is used to specify the number of seconds that must elapse when processing a remote operation before Microsoft SQL Server assumes the command failed or times out. The default is 600, which allows a ten minute wait. Remote server connections must be allowed before this value can be set.

You have to follow the steps as below to set up a time limit for remote queries in Microsoft SQL Server 2000.

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, and click Properties, and then select the Connections tab.

3. Now under Remote server connections set a value for Query time-out  (sec, 0 = unlimited): option.

4. Click OK.