>When a timeout is returned on an update command, where should we go to obtain the related information as to know where this is configured? I have an update command that failed about 30 seconds and I am trying to find if this was related to entirely the SQL Server configuration.
>
>The exact message was:
>
>"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
You can increase timeout in the config manager (in the connection string), but it may be also better to try to fine tune this update statement.
If it's not broken, fix it until it is.
My Blog