Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Threading model of Stored Procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-28 : 09:28:35
Binoy writes "Can you please let me know how a stored procedure is executed in the following scenario.

When many users access a same function which calls a stored procedure to update a table, how many processes/threads are created in the server. If the calls are executed in the same thread how are they serialized ?

Thanks

binoy"
   

- Advertisement -