USP_DATAFORMTEMPLATE_ADD_WEBERRORLOG

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@ERRORMESSAGE	nvarchar(1000)	IN
@ALTERRORID	nvarchar(15)	IN
@STACKTRACE	nvarchar(1000)	IN
@USERID	int	IN
@SITEID	int	IN
@ISWEB	bit	IN
@LOCALADDR	nvarchar(50)	IN
@REMOTEADDR	nvarchar(50)	IN
@SERVERNAME	nvarchar(100)	IN
@SCRIPTNAME	nvarchar(200)	IN
@QUERYSTRING	nvarchar(250)	IN
@USERAGENT	nvarchar(100)	IN
@FULLLOG	nvarchar(max)	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_ADD_WEBERRORLOG
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @ERRORMESSAGE nvarchar(1000) = '',
    @ALTERRORID nvarchar(15) = '',
    @STACKTRACE nvarchar(1000) = '',
    @USERID int = 0,
    @SITEID int = 0,
    @ISWEB bit = 1,
    @LOCALADDR nvarchar(50) = '',
    @REMOTEADDR nvarchar(50) = '',
    @SERVERNAME nvarchar(100) = '',
    @SCRIPTNAME nvarchar(200) = '',
    @QUERYSTRING nvarchar(250) = '',
    @USERAGENT nvarchar(100) = '',
    @FULLLOG nvarchar(max) = ''
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    -- handle inserting the data
    insert into dbo.WEBERRORLOG
        (ID, ERRORMESSAGE, ALTERRORID, STACKTRACE, USERID, SITEID, ISWEB, LOCALADDR, REMOTEADDR, SERVERNAME, SCRIPTNAME, QUERYSTRING, USERAGENT, FULLLOG, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @ERRORMESSAGE, @ALTERRORID, @STACKTRACE, @USERID, @SITEID, @ISWEB, @LOCALADDR, @REMOTEADDR, @SERVERNAME, @SCRIPTNAME, @QUERYSTRING, @USERAGENT, @FULLLOG, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

    -- and also let's not keep logs of ancient times
    delete from dbo.WEBERRORLOG where DATEADDED < dateadd(m, -6, getdate())
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0