stored proceduresThis is a discussion on stored procedures within the XML SOAP forums in Framework and Interface Programming category; Hi, I have a stored procedure which calls another sp, and this sp calls another sp, and so on ... The original/first sp is called from my windows app. What happens when one of the nested sp times out. Will the calling win app get an exception ? Which ex is triggered ? Thanks in advance regards, Andrew... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-08-2008, 06:51 AM
| |||
| |||
 stored procedures Hi, I have a stored procedure which calls another sp, and this sp calls another sp, and so on ... The original/first sp is called from my windows app. What happens when one of the nested sp times out. Will the calling win app get an exception ? Which ex is triggered ? Thanks in advance regards, Andrew  |
|
#2
09-08-2008, 07:14 AM
| |||
| |||
| Re: stored procedures Andrew wrote: > I have a stored procedure which calls another sp, and this sp calls another > sp, and so on ... The original/first sp is called from my windows app. > > What happens when one of the nested sp times out. Will the calling win app > get an exception ? Which ex is triggered ? Try microsoft.public.sqlserver.programming -- Martin Honnen --- MVP XML http://JavaScript.FAQTs.com/ |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 09:02 PM.
