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.
The connection timeout will not affect how long ADO.NET will wait for a query to complete...
Previous
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