General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>>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.
Connection timeout (which dictates how long ADO.NET will wait to establish a connection) is not the same as CommandTimeOut (which dictates how long it will wait for a query to complete)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only