[dbo].[uejm

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:37 AM Wednesday, March 07, 2007
Last Modified	11:09:13 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
alertid	nvarchar(64)	128
classname	nvarchar(32)	64
queue	nvarchar(32)	64
text	nvarchar(255)	510
server	nvarchar(32)	64
jobproperties	nvarchar(255)	510
urlname	nvarchar(32)	64
urllink	nvarchar(255)	510
status	int	4
severity	int	4
creationtime	decimal(18,0)	9
updatetime	decimal(18,0)	9
job	nvarchar(255)	510
jobset	nvarchar(255)	510

	Name	Columns	Unique
	$uejm__u000019ae00000000	alertid

SQL Script

CREATE TABLE [dbo].[uejm_alert]
(
[alertid] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[classname] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[queue] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[text] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[server] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobproperties] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[urlname] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[urllink] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL,
[severity] [int] NULL,
[creationtime] [decimal] (18, 0) NULL,
[updatetime] [decimal] (18, 0) NULL,
[job] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jobset] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[uejm_alert] ADD CONSTRAINT [$uejm__u000019ae00000000] PRIMARY KEY CLUSTERED ([alertid]) ON [PRIMARY]
GO