go
create proc		dbo.spTryTestA
as
--
raiserror('spTryTestA:1', 0, 1)
raiserror('spTryTestA:2', 16, 1)
raiserror('spTryTestA:3', 0, 1)
--(end)
go
create proc		dbo.spTryTestB
as
--
begin try
	raiserror('spTryTestB:1', 0, 1)
	exec dbo.spTryTestA
	raiserror('spTryTestB:2', 0, 1)
end try
begin catch
	raiserror('spTryTestB:3', 0, 1)
end catch
go
exec dbo.spTryTestA
exec dbo.spTryTestB
go

create proc dbo.spThrowError
as
--
declare			@errmsg				nvarchar(2048)
declare			@errno				int
declare			@errseverity		int
declare			@errstate			int
declare			@errline			int
declare			@errproc			nvarchar(126)
--
select			@errmsg				= error_message()
,				@errno				= error_number()
,				@errseverity		= error_severity()
,				@errstate			= error_state()
,				@errline			= error_line()
,				@errproc			= coalesce(error_procedure(), '-')
--
raiserror	(

				@errmsg				-- msg
,				@errseverity		-- severity
,				1					-- state
,				@errno				-- argument
,				@errseverity		-- argument
,				@errstate			-- argument
,				@errproc			-- argument
,				@errline			-- argument
			)
--(end)