Stanley,
You cannot force SQL Server to create a rowlock. Your method of using a table is what we do.
You may be able to check if a partictlar resource is locked but a row lock in SQL server will be very fast and probably not trackable.
thanks
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.