Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timeout on SQL Server
Message
De
18/04/2011 10:53:07
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01507700
Message ID:
01507714
Vues:
36
>>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...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform