asp classic - How to ignore errors from nested stored procedures in a SQL Server 2000 procedure called from ASP -

i working on "classic" asp application sql server 2000 database.

we have stored procedure (let's call sp0) calls other stored procedures (let's sp0.1, sp0.2 ...) call stored procedure called spx.

all procedures generate errors when goes wrong using raiserror().

we want able launch sp0 parameter @errorsinresultset change behaviour : instead of "re-raising" errors far, each sub-procedure log errors in temporary table #detectedproblems , return @ end.

adding errors temporary table not problem, can not figure out how ignore errors generated nested stored procedures.

i have done far :

exec @rc = [sp0.1] @errorsasresultset = @errorsasresultset       if (0 <> @@error) or (0 <> @rc)     begin         if (@errorsasresultset <> 0x1)         begin             raiserror('sp0.1: error table tests in db %s.%s', 16, 1, @@servername, @db)         end         goto failure     end 

this works fine, still generate errors lowest spx, prevent being executed ado in classic asp.

how can ignore errors ?

if you're happy errors being logged , it's safe continue, can use on error resume next on line before sp call. prevent page throwing errors.

to turn on errors later in page, can use on error goto 0