-- =============================================
CREATE PROCEDURE [dbo].[usp_InsertDBErrorLog]
AS
BEGIN
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO tblDbErrorLog (
NoOfErrors
,ErrorSeverity
,ErrorState
,ErrorProcedure
,ErrorLine
,ErrorMessage
)
VALUES (
ERROR_NUMBER()
,ERROR_SEVERITY()
,ERROR_STATE()
,ERROR_PROCEDURE()
,ERROR_LINE()
,ERROR_MESSAGE()
)
END
//------------------------------------------------------------------------
CREATE TABLE [dbo].[tblDbErrorLog](
[ErrorID] [int] IDENTITY(1,1) NOT NULL,
[NoOfErrors] [int] NULL,
[ErrorSeverity] [varchar](8000) NULL,
[ErrorState] [int] NULL,
[ErrorProcedure] [varchar](500) NULL,
[ErrorLine] [int] NULL,
[ErrorMessage] [varchar](8000) NULL,
[CreatedDate] [datetime] NULL,
CONSTRAINT [PK_tblDbErrorLog] PRIMARY KEY CLUSTERED
//===========================================