Tables [dbo].[logfile]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count30
Created4:53:07 PM Sunday, February 07, 2010
Last Modified4:53:08 PM Sunday, February 07, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
log_idint4
No
1 - 1
log_datedatetime8
No
error_numberint4
No
severityint4
No
sourcenvarchar(50)100
No
descriptionnvarchar(255)510
No
SQL Script
CREATE TABLE [dbo].[logfile]
(
[log_id] [int] NOT NULL IDENTITY(1, 1),
[log_date] [datetime] NOT NULL,
[error_number] [int] NOT NULL,
[severity] [int] NOT NULL,
[source] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
Uses