Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking a Record
Message
From
09/09/2014 13:38:00
 
 
To
09/09/2014 13:12:37
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01607215
Message ID:
01607217
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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform