<MarkusJNZ@gmail.com> wrote in message
news:1162445368.740135.246020@f16g2000cwb.googlegroups.com...
> Hi, I have a stored procedure which calls another stored procedure
>
> I would like to be able to capture any errors returned by the child
> procedures in the parent.
>
> I thought I might be able to do something like this (Given two stored
> procs) A and B
>
> create procedure A
> as
> begin
> exec B
> if@@error<>0
> print @@error
> end
>
> Procedure B would call the RAISERROR function and A would be able to
> capture it.
>
> Unfortunately, this does not seem to work. I could use return values
> from B but was hoping for further insight.
>
> Thanks
> Markus
>

> Unfortunately, this does not seem to work. I could use return values
> from B but was hoping for further insight.

Scott Morris wrote:

> > Unfortunately, this does not seem to work. I could use return values
> > from B but was hoping for further insight.
>
> Define "does not seem to work". Works for me using the correct logic (along
> with an example of incorrect logic). It may help to refer to the
> documentation in BOL regarding @@ERROR and how it is set. Erland has a much
> better discussion about error handling in tsql.
>
> create procedure testa as
> RAISERROR('Not allowed',11,-1) WITH SETERROR
> go
>
> create procedure testb as
> declare @err int
> exec testa
> set @err = @@ERROR
>
> if @err <> 0
> print @err
> go
>
> create procedure testc as
> exec testa
> if @@ERROR <> 0
> print @@ERROR
> go
>
> exec testb
> exec testc
> go
>
> drop procedure testa
> drop procedure testb
> drop procedure testc
> go