Hi Jess,

In addition to sergey, uou might want to wrap all of this into one transaction and set the transactionlevel to serializable. see help for SET TRANSACTION ISOLATION LEVEL

Walter,

>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?