Description
Used by the SQL Web Event Provider to log event data.
Columns
| Name |
Type |
Required? |
Defaults To |
Description |
| EventId |
char(32) |
Yes |
|
Event ID (from WebBaseEvent.EventId)
|
| EventTimeUtc |
datetime |
Yes |
|
UTC time at which the event was fired (from WebBaseEvent.EventTimeUtc)
|
| EventTime |
datetime |
Yes |
|
Local time at which the event was fired (from WebBaseEvent.EventTime)
|
| EventType |
nvarchar(256) |
Yes |
|
Event type (for example, WebFailureAuditEvent)
|
| EventSequence |
decimal(19) |
Yes |
|
Event sequence number (from WebBaseEvent.EventSequence)
|
| EventOccurrence |
decimal(19) |
Yes |
|
Event occurrence count (from WebBaseEvent.EventOccurrence)
|
| EventCode |
int |
Yes |
|
Event code (from WebBaseEvent.EventCode)
|
| EventDetailCode |
int |
Yes |
|
Event detail code (from WebBaseEvent.EventDetailCode)
|
| Message |
nvarchar(1024) |
No |
|
Event message (from WebBaseEvent.EventMessage)
|
| ApplicationPath |
nvarchar(256) |
No |
|
Physical path of the application that generated the Web event (for example, C:\Websites\MyApp)
|
| ApplicationVirtualPath |
nvarchar(256) |
No |
|
Virtual path of the application that generated the event (for example, /MyApp)
|
| MachineName |
nvarchar(256) |
Yes |
|
Name of the machine on which the event was generated
|
| RequestUrl |
nvarchar(1024) |
No |
|
URL of the request that generated the Web event
|
| ExceptionType |
nvarchar(256) |
No |
|
If the Web event is a WebBaseErrorEvent, type of exception recorded in the ErrorException property; otherwise, DBNull
|
| Details |
ntext |
No |
|
Text generated by calling ToString on the Web event
|
Indexes
| Name |
Type |
Columns |
| PK__aspnet_WebEvent___5FB337D6 |
Unique, Clustered |
EventId |
Definition
CREATE TABLE [aspnet_WebEvent_Events]
(
[EventId] char(32) NOT NULL,
[EventTimeUtc] datetime NOT NULL,
[EventTime] datetime NOT NULL,
[EventType] nvarchar(256) NOT NULL,
[EventSequence] decimal(19) NOT NULL,
[EventOccurrence] decimal(19) NOT NULL,
[EventCode] int NOT NULL,
[EventDetailCode] int NOT NULL,
[Message] nvarchar(1024) NULL,
[ApplicationPath] nvarchar(256) NULL,
[ApplicationVirtualPath] nvarchar(256) NULL,
[MachineName] nvarchar(256) NOT NULL,
[RequestUrl] nvarchar(1024) NULL,
[ExceptionType] nvarchar(256) NULL,
[Details] ntext NULL
CONSTRAINT [PK_aspnet_WebEvent_Events] PRIMARY KEY
(
[EventId]
)
)
ASP.NET 2.0 Provider Database