Modify the CLR stored procedure timeout setting

A CLR stored procedure calls the web service to fetch and audit data. SQL Server parameters, such as size, configuration, and network latency can affect the web service response time, so adjust the timeout setting if needed to prevent timeouts.

• Use the Ampla CLRWebServiceTimeout registry key to specify the timeout value. The default is 100 seconds. Choose an appropriate timeout setting carefully, as higher values can negatively impact overall system performance.