a template for an example procedure

ALTER PROCEDURE [dbo].[procUtils_ExampleProc]

@domain_user varchar(50) ,
@msgOut varchar(4000) OUT,
@debugMsgOut varchar(4000) OUT ,
@ret int OUT

AS
BEGIN -- proc start
SET NOCOUNT ON;

declare @procedureName varchar(200)
set @procedureName = ( SELECT OBJECT_NAME(@@PROCID))
set @msgOut = ' '
set @debugMsgOut = ' '



BEGIN TRY --begin try
set @ret = 1 --assume false from the beginning

set @msgOut = 'Retrieved Report Successfully'
set @ret = @@ERROR


return @ret

END TRY --end try

BEGIN CATCH
PRINT 'In CATCH block.
Error number: ' + CAST(ERROR_NUMBER() AS varchar(10)) + '
Error message: ' + ERROR_MESSAGE() + '
Error severity: ' + CAST(ERROR_SEVERITY() AS varchar(10)) + '
Error state: ' + CAST(ERROR_STATE() AS varchar(10)) + '
XACT_STATE: ' + CAST(XACT_STATE() AS varchar(10));

set @msgOut = 'Failed to retrieve Report '
set @debugMsgOut = ' Error number: ' + CAST(ERROR_NUMBER() AS varchar(10)) +
'Error message: ' + ERROR_MESSAGE() + 'Error severity: ' + CAST(ERROR_SEVERITY() AS varchar(10)) +
'Error state: ' + CAST(ERROR_STATE() AS varchar(10)) + 'XACT_STATE: ' + CAST(XACT_STATE() AS varchar(10))

END CATCH


return @ret
END --procedure end