>>We have a Visual Foxpro app and it uses SQL Server database. The app gets series no. from a table by using stored procedure. Is it right to assume that if a 100 users simultaneously running the application, the SQL Server manages the execution of the SP in a QUEUED manner? Meaning, the SQL Server should finish the execution of the SP before allowing another one to access or execute it again?
>
>Nope, all users can execute this stored procedure at the same time if they have rights to execute it..

So it's possible that two users gets the same series no.? The Stored Procedure looks like this:

Create Stored Procedure GetSeriesNo
@doccode VarChar(10)
As
Update ccdoc
Set seriesno = seriesno + 1
Where doccode = @doccode

Select seriesno From ccdoc Where doccode = @doccode