By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PROCEDURE [dbo].[FirstProc]
AS
BEGIN
BEGIN TRY
declare @n varchar(200) = 'sys.objects_not_real_table';
if (OBJECT_ID(@n, 'U') is null)
begin
set @n += ' is missing';
raiserror(@n, 16, 1);
-- or throw:
--throw 50001, @n, 1;
end
SELECT name
FROM sys.objects_not_real_table;
END TRY
BEGIN CATCH
SELECT 'Error from First Proc: ' + ERROR_MESSAGE();
END CATCH
END
CREATE PROCEDURE [dbo].[SecondProc]
AS
BEGIN
BEGIN TRY
EXEC FirstProc;
SELECT 'eoj [FirstProc]';
END TRY
BEGIN CATCH
SELECT 'Error from SECOND PROC';
END CATCH
END
Exec [SecondProc]
| (No column name) |
|---|
| Error from First Proc: sys.objects_not_real_table is missing |
| (No column name) |
|---|
| eoj [FirstProc] |