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 |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2007-07-04 : 17:38:56
|
| I have a stored procedure that when ran from my SSMS it takes approx 27-30 seconds to run and complete. However when I run it from my .net Application it times out.I set the time out period to 0 (No Time out) and the procedure seems now last forever then w/o ever getting the results. Does anyone know what I can do to try and resolve this? It's very strange that it works w/o issue from ssms (On the same machine), but not from the .net app. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 21:04:05
|
| Did you see that process with 'sp_who2 active'? May stuck somewhere between web and sql. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-07-05 : 05:49:06
|
| "when ran from my SSMS"is SSMS running on the server, or a client machine?If the Server then how much data is being returned? If the output is LOTS of data then it might be a network issue, not a SQL issue.Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Timeing out