Walter Meester
HoogkarspelPays-Bas
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?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement