Create PROC uspErrorLog
(
@userId varchar(15) ,
@ExcType varchar(255)='',
@ExcMessage varchar(255)='',
@ExcSource varchar(255)='',
@ExcStackTrace varchar(255)=''
,@pageUrl varchar(150)=''
,@methodName varchar(150)=''
,@lineNo int
,@timeZone varchar(150)
)
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO [Common].[ErrorLogs]
([userId]
,[ExceptionType]
,[ExceptionMessage]
,[ExceptionSource]
,[ExceptionStackTrace]
,[pageUrl]
,[MethodName]
,[LineNumber]
,[Timezone]
,[LogDate])
VALUES
( @userId
,@ExcType
,@ExcMessage
,@ExcSource
,@ExcStackTrace
,@pageUrl
,@methodName
,@lineNo
,@timeZone
,getdate()
)
COMMIT TRAN
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
SELECT NULL AS ID
,'Cant Perform Insert Action.Error:' + Error_message() AS Message
,ERROR_LINE() AS linentto
ROLLBACK TRAN
END CATCH
END
And call this procedure in your stored procedures in {catch} by passing the variables.Like this
开始捕获
IF @@TRANCOUNT > 0
SELECT NULL AS ID
,'Cant perform operation.Error:' + Error_message() AS Message
,ERROR_LINE() AS linoo
ROLLBACK TRAN
DECLARE @methodname VARCHAR(200)
,@msg VARCHAR(max)
,@lineno INT
SET @methodname = (
SELECT Error_procedure()
)
SET @msg = (
SELECT Error_message()
)
SET @lineno = (
SELECT Error_line()
)
EXEC [dbo].[uspErrorLog] @CreatedBy
,''
,@msg
,''
,''
,''
,@methodname
,@lineno
,''
结束捕获
sys.messages
中,因此您可以查询其中可能的关键字。 - Martin Smith