TRY...CATCH errors into and error log table

Question

I'm having a problem with TRY...CATCH blocks. Can someone explain why the following code will not execute my sp?

DECLARE @Result int
SET @Result = 0
BEGIN TRY
    SELECT * FROM TableNoExist
END TRY
BEGIN CATCH
    SET @Result = ERROR_NUMBER()
END CATCH
EXEC dbo.spSecurityEventAdd @pSecurityEventTypeID = 11, @pResult = @Result

But this code does work:

DECLARE @Result int
SET @Result = 0
BEGIN TRY
    SELECT 1/0
END TRY
BEGIN CATCH
    SET @Result = ERROR_NUMBER()
END CATCH
EXEC dbo.spSecurityEventAdd @pSecurityEventTypeID = 11, @pResult = @Result

I'd like to make sure I catch all errors. Thanks

Irwin M. Fletcher · Accepted Answer · 2010-02-26 21:49:56Z

2

Compile and Statement-level Recompile Errors

There are two types of errors that will not be handled by TRY…CATCH if the error occurs in the same execution level as the TRY…CATCH construct:

Compile errors, such as syntax errors that prevent a batch from executing.

Errors that occur during statement-level recompilation, such as object name resolution errors that happen after compilation due to deferred name resolution.

http://msdn.microsoft.com/en-us/library/ms179296.aspx

answered Feb 26, 2010 at 21:49

Irwin M. Fletcher

2,6663 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

davecoulter · Accepted Answer · 2010-02-26 21:54:22Z

1

It looks like this thread answers your question.

answered Feb 26, 2010 at 21:54

davecoulter

1,82413 silver badges15 bronze badges

Collectives™ on Stack Overflow

TRY...CATCH errors into and error log table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related