I have code similar to this in a PK generator. To make sure, I wrap it in a transaction. I didn't want the the multi-threaded nature of SQL Server biting me.

>Hi:
>
>I'm using the following code fragment in an SP to generate unique case id numbers:
>
> update Counters set nxtcaseno = nxtcaseno + 1
> set @retval = (select nxtcaseno from Counters)
>
>I've used code similiar to this in FoxPro for a long time without ever getting a duplicate. However, I'm using it in SQL Server for the first and wonder if it is safe enough? Should I wrap this into a manual transaction or is the implicit transaction good enough?
>
>Thanx,
>Charlie