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 |
|
sona
Yak Posting Veteran
68 Posts |
 Posted - 2001-12-11 : 02:03:38
|
| When I call a sp , within another sp, the second one get timed out if it executes more than 30 secs. Is there any limitations for calling nested procedures.(The Query Time out is set as zero) |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-11 : 14:23:45
|
| Where is this originally being called from? Most Timeout questions I see come from ASP pages timing out. And 99% of them timeout because the queries they are running are written inefficiently (often due to the use of cursors and looping, or lack of proper indexes). If you are willing to post some code we might be able to help you tune your sprocs.-------------------It's a SQL thing... |
 |
|
|
|
|
|
Timeout