How to set the Remote Query Timeout value for your Silk Test SQL Database.
The Remote Query Timeout value specifies how long, in seconds, a remote operation can take before the SQL Server times out. This value applies to an outgoing connection initiated by the Database Engine as a remote query.
To set this value for your Silk Test SQL Database, please follow the guide below.
1: Access the Silk Database Maintenance tool and open your database. Select the Data Source and enter the required owner, user id and password.
2: Click on Options > Configure. In here you will be able to modify the "Query Timeout" value. By default the value is set to '600' seconds or 10 minutes. Alternatively, to disable the timeout setting, set the value to '0'. A Query will wait until it is canceled.
Alternatively, the Remote Query Timeout value can also be modified by your Database Administrator (DBA) within the SQL Server Management Studio.