Error Log in SQL Server

begin try
SET NOCOUNT ON;
//SQL STATEMENT


  end try

  begin catch
   EXEC sp_helptext 'PROC_SQL_ERROR_TRACE'
  end catch




CREATE PROCEDURE [dbo].[Proc_SQL_Error_Trace]
AS

BEGIN
 
  DECLARE @ErrorNumber VARCHAR(MAX)  
  DECLARE @ErrorState VARCHAR(MAX)  
  DECLARE @ErrorSeverity VARCHAR(MAX)  
  DECLARE @ErrorLine VARCHAR(MAX)  
  DECLARE @ErrorProc VARCHAR(MAX)  
  DECLARE @ErrorMesg VARCHAR(MAX)  
  DECLARE @UserName VARCHAR(MAX)  
  DECLARE @HostName VARCHAR(MAX)

  SELECT  @ErrorNumber = ERROR_NUMBER()  
       ,@ErrorState = ERROR_STATE()  
       ,@ErrorSeverity = ERROR_SEVERITY()  
       ,@ErrorLine = ERROR_LINE()  
       ,@ErrorProc = ERROR_PROCEDURE()  
       ,@ErrorMesg = ERROR_MESSAGE()  
       ,@UserName = SUSER_SNAME()  
       ,@HostName = Host_NAME()  
 
INSERT INTO SQL_Error_Trace(ErrorNumber,ErrorState,ErrorSeverity,ErrorLine,
 ErrorProc,ErrorMsg,UserName,HostName,ErrorDate)  
VALUES(@ErrorNumber,@ErrorState,@ErrorSeverity,@ErrorLine,@ErrorProc,
 @ErrorMesg,@UserName,@HostName,GETDATE())  
END