>AFAIK, there's no equivalent of FLOCK in SQL Server. Why no autoinc or GUID fields?
>
>>I use the follow code to get Unique Keys with VFP tables
>>
>>Local lgetUniqueKey
>>Use myCounter
>>IF Flock()
>> Replace myCounter.counter With myCounter.counter+1
>> lgetUniqueKey= myCounter.counter
>> Flush In myCounter Force
>> Unlock
>>Endif
>>
>>Could you suggest some equivalent code if the MyCounter table is an MSSQL table?
>>Please no autoinc field or global unique identifiers

This procedure is not only for Unique record key but for invoice numbers etc. as well.