>>There is no record locking in SQL Server as in VFP. You can use query hints in order to achieve some locking, but I don't think it's a recommended approach.
>
>So what is the recommended approach ?
Let SQL Server apply locks as it sees fit.
If it's not broken, fix it until it is.
My Blog