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.
| Author |
Topic |
|
mmdullah
Starting Member
10 Posts |
 Posted - 2010-02-24 : 00:12:58
|
| Dear all,I need to know what happens when a sp is executing under a button click (asp.net). While sp is executing (say it takes 50 sec to execute), if another button is clicked ( so another http request is sent to the asp.net server), what will happen to the running sp? second button just marely updates a dropdown list.thanks for your time.mir |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-24 : 01:45:07
|
| Make a test?Make two Sprocs, one with WAITFOR DELAY 00:00:25 and then INSERT into a table (to log that it finished), second sproc immediately logs to table and returns.I recommend keeping the delay for the first one under 30 seconds - which is often the default timeout.In ASP I'm pretty sure the first Sproc will run to completion - and then its results will be cancelled by ASP. But I don't know about ASP.NET. |
 |
|
|
|
|
|
Behaviour of sp when another http request is sent