To change the SQL timeout setting for your application, update the config settings in your application's config files on the web server. Create a user.config file with the following contents or, if one already exists, update it with the new key value:
<appSettings>
<add key="VersionOne.Data.Sql2k.CommandTimeout" value="90"/>
</appSettings>
Notes:
- The above sets the SQL timeout to 90 seconds
- If the key is not present, the default timeout is 60 seconds
- A value of 0 means no timeout
- Web servers time out after 90 seconds, so setting the SQL timeout to any higher value will just cause web server timeouts