Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Blocking issue using MS SQL Server
Message
From
11/09/2004 04:38:48
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
11/09/2004 04:23:53
General information
Forum:
Visual FoxPro
Category:
Visual ProMatrix
Miscellaneous
Thread ID:
00940503
Message ID:
00941288
Views:
19
Hi,
The Blocks can be caused by a lot of different reasons, coding mainly and occassionly hardware. I would look at the following.
1. Dangling objects.
2. Incomplete transactions.
3. Transaction stalled waiting on a triggered call to another locked file.
4. Hardware malfunction. Does one workstation start the problem.
5. Operator doing something weird.

Hope this helps. These can take time to resolve, especially if you didn't write the code or stored proceedures.
Regards N Mc Donald
Previous
Reply
Map
View

Click here to load this message in the networking platform