Question about error handler

In store procedure, when a statement has error and Severity is high, so eror
is occured and stop the stored procedure and exit the sp. So I cannot use
@.@.error to catch the error. Is there any way that I can proceed the sp and
don't let it stoped so that I can use @.@.error to catch the error and make th
e
sp much nicely. Thanks.I am afraid that the answer is "no". You will have to capture the error at
the client side. See if this helps.
Implementing Error Handling with Stored Procedures
http://www.sommarskog.se/error-handling-II.html
Error Handling in SQL Server – a Background
http://www.sommarskog.se/error-handling-I.html
AMB
"Iter" wrote:

> In store procedure, when a statement has error and Severity is high, so er
or
> is occured and stop the stored procedure and exit the sp. So I cannot use
> @.@.error to catch the error. Is there any way that I can proceed the sp and
> don't let it stoped so that I can use @.@.error to catch the error and make
the
> sp much nicely. Thanks.
>