Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locking a Record
Message
De
09/09/2014 14:31:54
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
09/09/2014 13:38:00
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
Application:
Web
Divers
Thread ID:
01607215
Message ID:
01607222
Vues:
59
>Absolutely a bad a idea. Scenario: System crashes, user goes on vacation. Record is locked for extended period. They'll never remember to fix it when they get back.
>
>>Or the first person to start the record marks it pending with their userid. If they lose the connection, only they can re-access the record. Any record without an id is available to be received.

Totally agreed. The first was a good way. Or - the second is a bad way...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform