Hi folks,

I am upsizing a system from VFP to SQL Server and want to carry on using semaphore locking. In VFP I could do something like

IF semaphorelock("tablename", id)
*-- ok

This would add a new record to the table for the tablename/id combination (if it didn't exist) and also RLOCK() it at the same time (in case user crashes).

However whilst I know I could write a stored proc to do the writing to table etc I'm not really sure how to explicitly do a RLOCK in SQL Server. From what I've read SQL Server seems to perform a dynamic lock i.e. it determines itself whether the table should be page locked etc.

Any ideas ?

Kal