Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Timeout expired in Delete transaction
Message
 
To
01/06/2001 19:47:20
Oscar Ruiz
American Industries
Chihuahua, Mexico
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00514089
Message ID:
00514100
Views:
12
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform