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

date: Mon, 8 Sep 2008 03:51:01 -0700   author:   Andrew

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/

date: Mon, 08 Sep 2008 13:14:53 +0200   author:   Martin Honnen