Сценарий на SQL для создания OWALogon
 if exists (select * from dbo.sysobjects where id = object_id(N?[dbo].[OWALogon]?) and OBJECTPROPERTY(id, N?IsUserTable?) = 1)
drop table [dbo].[OWALogon]
GO

CREATE TABLE [dbo].[OWALogon] (
	[strDate] [varchar] (10) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[strTime] [varchar] (8) COLLATE Cyrillic_General_CI_AS NOT NULL ,
	[strUserName] [varchar] (50) COLLATE Cyrillic_General_CI_AS NULL ,
	[strDisplayName] [varchar] (1024) COLLATE Cyrillic_General_CI_AS NULL ,
	[strUserIP] [varchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
	[strAuth] [varchar] (7) COLLATE Cyrillic_General_CI_AS NULL ,
	[strHTTPCode] [varchar] (3) COLLATE Cyrillic_General_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]GO

Поделитесь материалом с коллегами и друзьями