>It works the same way on SQL Server with the syntax difference (HOLDLOCK)
>*** Stored Procedure
>Begin tran
>Select @my_id=id from TSetup HOLDLOCK where code=55
>Update TSetup Set id=@my_id+1 where code=55
>Commit tran

Oh, but I don't have SQL-Server on the server ! (sigh)
Users will have access to the remote tables using remote views...