Procedure: aspnet_WebEvent_LogEvent

Description

Records a Web event in the aspnet_WebEvents_Events table.

Parameters

Name	Type	Direction
@EventId	char	Input
@EventTimeUtc	datetime	Input
@EventTime	datetime	Input
@EventType	nvarchar	Input
@EventSequence	decimal	Input
@EventOccurrence	decimal	Input
@EventCode	int	Input
@EventDetailCode	int	Input
@Message	nvarchar	Input
@ApplicationPath	nvarchar	Input
@ApplicationVirtualPath	nvarchar	Input
@MachineName	nvarchar	Input
@RequestUrl	nvarchar	Input
@ExceptionType	nvarchar	Input
@Details	ntext	Input

Definition

CREATE PROCEDURE dbo.aspnet_WebEvent_LogEvent
        @EventId         char(32),
        @EventTimeUtc    datetime,
        @EventTime       datetime,
        @EventType       nvarchar(256),
        @EventSequence   decimal(19,0),
        @EventOccurrence decimal(19,0),
        @EventCode       int,
        @EventDetailCode int,
        @Message         nvarchar(1024),
        @ApplicationPath nvarchar(256),
        @ApplicationVirtualPath nvarchar(256),
        @MachineName    nvarchar(256),
        @RequestUrl      nvarchar(1024),
        @ExceptionType   nvarchar(256),
        @Details         ntext
AS
BEGIN
    INSERT
        dbo.aspnet_WebEvent_Events
        (
            EventId,
            EventTimeUtc,
            EventTime,
            EventType,
            EventSequence,
            EventOccurrence,
            EventCode,
            EventDetailCode,
            Message,
            ApplicationPath,
            ApplicationVirtualPath,
            MachineName,
            RequestUrl,
            ExceptionType,
            Details
        )
    VALUES
    (
        @EventId,
        @EventTimeUtc,
        @EventTime,
        @EventType,
        @EventSequence,
        @EventOccurrence,
        @EventCode,
        @EventDetailCode,
        @Message,
        @ApplicationPath,
        @ApplicationVirtualPath,
        @MachineName,
        @RequestUrl,
        @ExceptionType,
        @Details
    )
END

---

ASP.NET 2.0 Provider Database