Thank you:-)

updated one.............

AS

/*

==================================================================================================

Name : p_ECR_Handle_Error

Author : *************************

Description : Used for error handling in catch block

===================================================================================================

Returns : 0 for success and -1 for failure

Usage:

EXEC some_sp

EXEC outer_sp

exec ims.p_KCR_Handle_Error

Example:

drop PROCEDURE some_sp;

go

CREATE PROCEDURE...

you are right....i had the wrong nestlevels.....if i comment out the nestlevels it is working.....but raiserrror() is executing from catch block not the try block....

use dbname

go

drop procedure dbo.p_inner

go

create procedure dbo.p_inner

as

select 1,NULL,NULL

select 2,3,4

go

drop procedure dbo.p_outer

go

create procedure dbo.p_outer

as

declare @t table (id int, c1 int, c2 int)

insert @t (id, c1,c2)

exec dbo.p_inner

select * from @t

go

exec dbo.p_inner

exec dbo.p_outer

I have...

Hi everyone,

I have this error output in SSMS for the following query

exec Master..xp_cmdshell 'bcp "select blobdata from SynDocs.dbo.BLOBDATA where blobid = 2" queryout "c:\filename2.img" -S ROK-W7STHONUK-7 -T'

The output is 2...