Configure Query Timeout Period in SQL Management Studio

In SQL the error “The timeout period elapsed prior to completion of the operation or the server is not responding” is due to the default timeout period for queries executed in SQL Management Studio of 30 seconds.

sms_error

This error is resolved by adjusting the timeout period from the following locations.

  1. Open SQL Management Studio
  2. Click Tools > Options
  3. Expand Query Execution
  4. Expand SQL Server
  5. Select General
  6. Adjust Execution time-out:sms_optionsgeneral
  7. Select Designers
  8. Adjust Transaction time-out after:sms_optionsdesigners

If neither of these adjustments allow the query to execute you can create a registry entry which overrides the default configuration by running the following command from the command line.  The value of 300 is 300 seconds (5 minutes).

REG ADD "HKCU\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\DataProject" /v SQLQueryTimeout /t REG_DWORD /d 300 /f