Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking a Record
Message
From
09/09/2014 14:31:54
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
09/09/2014 13:38:00
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01607215
Message ID:
01607222
Views:
61
>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...
Previous
Reply
Map
View

Click here to load this message in the networking platform