[dbo].[seosdata]

Property	Value
Heap
Row Count	0
Created	11:07:30 AM Wednesday, March 07, 2007
Last Modified	11:09:43 AM Wednesday, March 07, 2007

Name	Data Type	Collation	Max Length (Bytes)
entryid	int		4
domainname	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
username	nvarchar(214)	SQL_Latin1_General_CP1_CS_AS	428
eventtype	int		4
logname	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
timstamp	datetime		8
source	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
computername	nvarchar(214)	SQL_Latin1_General_CP1_CS_AS	428
eventid	int		4
eventcategory	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
searchstrings	nvarchar(255)	SQL_Latin1_General_CP1_CS_AS	510
msgtext	ntext	SQL_Latin1_General_CP1_CI_AS	max

Name	Columns	Unique
baseidx_seosdata	entryid
ix_computername	computername
ix_timestamp	timstamp
ix_username	username

SQL Script

CREATE TABLE [dbo].[seosdata]
(
[entryid] [int] NULL,
[domainname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[username] [nvarchar] (214) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[eventtype] [int] NULL,
[logname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[timstamp] [datetime] NULL,
[source] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[computername] [nvarchar] (214) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[eventid] [int] NULL,
[eventcategory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[searchstrings] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[msgtext] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_computername] ON [dbo].[seosdata] ([computername]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_seosdata] ON [dbo].[seosdata] ([entryid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_timestamp] ON [dbo].[seosdata] ([timstamp]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_username] ON [dbo].[seosdata] ([username]) ON [PRIMARY]
GO