>Currently what we do is lock the user record, as well as set a flag for the user. We count the flags first and check for the locks only when we actually reach the license number limit. And this has been serving our needs quite well.
>The problem now is that we plan to use SQL Server as the backend with the next version, and are not sure we can really Lock a record there? Do u think something like this would be possible with SQL server?
>
>Thanks for your time!

No, I don't think you can do that with SQL Server, but someone with more experience with it could jump in here and say differently.