SQL Error Logs

logs-errors.sql

CREATE SCHEMA logs AUTHORIZATION dbo

CREATE TABLE [logs].[Errors](
	[ErrorId] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](100) NULL,
	[ErrorNumber] [int] NULL,
	[ErrorState] [int] NULL,
	[ErrorSeverity] [int] NULL,
	[ErrorLine] [int] NULL,
	[ErrorProcedure] [varchar](max) NULL,
	[ErrorMessage] [varchar](max) NULL,
	[ErrorDateTime] [datetime2](7) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

stored-proc.sql

	BEGIN TRY  
		BEGIN TRANSACTION
		
		COMMIT
	END TRY  
	BEGIN CATCH  
		ROLLBACK
		INSERT INTO logs.Errors VALUES
		  (SUSER_SNAME(),
		   ERROR_NUMBER(),
		   ERROR_STATE(),
		   ERROR_SEVERITY(),
		   ERROR_LINE(),
		   ERROR_PROCEDURE(),
		   ERROR_MESSAGE(),
		   GETUTCDATE());
		   THROW
	END CATCH