ALTER PROCEDURE [dbo].[TEST_TRY] 
 
AS
BEGIN
BEGIN TRY
    -- Table does not exist; object name resolution
    -- error not caught.
    SELECT * FROM NonexistentTable;
END TRY
BEGIN CATCH
    SELECT 
        ERROR_NUMBER() AS ErrorNumber
        ,ERROR_MESSAGE() AS ErrorMessage;
RETURN -1;
END CATCH
RETURN 0;
END

USE [DBTest]
GO
 
DECLARE	@return_value int
 
EXEC	@return_value = [dbo].[TEST_TRY]
 
SELECT	'Return Value' = @return_value
 
GO