CODEWITHSUNDEEP
sql-server-2005stored-procedures
subs
subs

Reputation: 2249

Calling a stored procedure simultaniously from multiple threads in asp.net and sql server 2005

Is it possible to call a stored procedure from multiple threads simultaneously?

I want to know whether this is possible in sql server 2005. How does SQl server handle this?

Will it throw an error or will it create multiple instance of the stored procedure and run it?

I know i should use locks for this. But I want to know what will happen if I don't.

Thanks, Syd

Upvotes: 2

Views: 3501

Answers (1)

Oded
Oded

Reputation: 499002

Yes, this is possible.

SQL Server will handle this fine - that's what databases do, handle multiple connections simultaneously.

I don't know what you mean by "multiple instance of the stored procedure" - there is only one definition of a SP in the database and that will get executed. It can be executed by many threads if needed. The database will handle the concurrency for you.

Use of locks depends on the application and how you access the database (and the meaning of the actions you take - whether they need to be atomic/serializable etc).

Upvotes: 4

Related Questions