Hi

What's the best way to lock a specific record within a stored procedure? I have 3 fields in my table called LockedBy (char 64), LockedByID (int 10) and LockedByDateTime (smalldatetime). When I perform a record lock I'd like to update those fields in the table so that any other calling procedure can see who has locked the record and when.

Obviously, within my SQL stored procedure I'd need to pass in the LockedBy and LockedByID values, attempt a record lock, update the 3 fields, then finally I'd remove the record lock. The reason I don't want to let SQL continue to lock the record is because the user may have the record open for 60 minutes, so by using these 3 fields I can check if a record has been locked just by interrogating those fields. Once the user has finished with the record I would just do a reverse of the process.

What's the best way to go about this?

Regards