SP Examples

-- =============================================

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

//===========================================