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