bypassign error

[camy123]

guys need your help please
I have a store procedure runnign via scheduler and sql agent keeps aborting it when it comes to a certain error what i need is to nto allow the script to be aborted even tho there is a error there ne ideas
Please

 

[JamesLean]

What is the full error? Any error of level 16 and above will automatically stop the batch.

--James

 

[camy123]

Im not sure of the error to hand but does that mean theres no way to trap the error and allow the script to carry on...if @@error > 16

 

[JamesLean]

What you can do is put the code that you want to check inside a stored proc. Then check the return value from that:

CREATE PROC invalid
AS

--error - divide by zero
SELECT 1/0
GO

DECLARE @ret int

EXEC @ret = invalid
IF @ret <> 0
	PRINT 'An error occured in the SP'
ELSE
	PRINT 'All ok'

--James