Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timeout expired in Delete transaction
Message
 
À
01/06/2001 19:47:20
Oscar Ruiz
American Industries
Chihuahua, Mexique
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00514089
Message ID:
00514100
Vues:
13
>When I try to execute a SQL transaction in Visual Basic using Delete from Receipts where ... sentence, in a table with a lot of records (near to 2,000,000) it return a error message "timeout expired".
>When I try to execute this sentence in SQL Analizer it ends in 2 or 3 minutes.
>Which is causing the tha trasaction abort?. Is there a way of changing the value of this timeout?

Which data access method are you using? In VB, see the CommandTimeOut property. Also, you should consider checking your indexes. It seems quite long!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform