>Hi
>
>I am trying to lock a table row in a table that manages field no sequences
>
>Here's my code:
>
>

BEGIN TRAN
>
>SELECT * FROM NEXTID WITH (HOLDLOCK, ROWLOCK) WHERE Cdbfname = 'JOBNO'
>
>mjobno=sqlResults.iNextNo
>
>UPDATE NEXTID SET iNextNo=InextNo+1 FROM NEXTID WITH (HOLDLOCK, ROWLOCK) WHERE Cdbfname = 'JOBNO'
>
>/* Do all your stuff here while the record is locked */
>
>COMMIT TRAN
>

>
>Basically I want one user to go through this code at a time, I thought the begin tran would
>do what I want?
>
>EDIT: I have selected Internet application in the desc, but it is should say desktop application :)
>
>Any help extremely appreciated

I think you don't need any parameters like holdlock or rowlock between begin and end tran. But you have to use begin/end trans carefully. You may cause deadlock.