Overview

Starting with SQL Search 3.9.10, a configuration file is available that allows you to customize the query executions timeout used by SQL Search.

This can be useful in environments with:

• Large databases
• Complex object definitions
• Searches that take longer than the default timeout period

Configure the Timeout

1. Open the SQL Search configuration located within the SQL Search folder under your local AppData directory. 
   
   SSMS
   AppData\Local\Red Gate\RedGate.SQLSearch.Addin 3\SQLSearchSavedSettings.xml
   
   Visual Studio
   AppData\Local\Red Gate\RedGate.SQLSearch.Addin for Visual Studio 3\SQLSearchSavedSettings.xml
   
   
2. Locate the ExecutionTimeout setting.
3. The default execution timeout is 30 seconds.
4. Modify the value to the required number of seconds. 
5. Save the file
6. Restart SSMS / Visual Studio

Example

The following example increases the SQL Search query execution timeout from the default value of 30 seconds to 120 seconds:

<?xml version="1.0"?>
<Configuration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <ExecutionTimeout>120</ExecutionTimeout>
</Configuration>