· 8 years ago · Feb 21, 2018, 05:28 PM
1DROP TABLE IF EXISTS [DATABASENAMEHERE].[dbo].[WinEvent]
2GO
3
4CREATE TABLE [DATABASENAMEHERE].[dbo].[WinEvent] (
5 [id] int IDENTITY(1,1),
6 [TimeCreated] datetime NOT NULL,
7 [LogName] varchar(60) NOT NULL UNIQUE,
8 [ProviderName] varchar(100) NOT NULL,
9 [EventId] integer NOT NULL,
10 [LevelDisplayName] varchar(100),
11 [Message] varchar(MAX)
12 CONSTRAINT [PK_WinEvent] PRIMARY KEY CLUSTERED
13 (
14 [id] ASC
15 ) WITH (IGNORE_DUP_KEY = OFF)
16
17)
18GO