Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2014
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only