USE [EnVisage]
GO

/****** Object:  Table [dbo].[supt_ImportErrors]    Script Date: 08/28/2015 3:45:01 PM ******/
IF (EXISTS (SELECT * 
    FROM INFORMATION_SCHEMA.TABLES where
    TABLE_NAME = 'supt_ImportErrors'))
DROP TABLE [dbo].[supt_ImportErrors]


/****** Object:  Table [dbo].[supt_ImportErrors]    Script Date: 08/28/2015 3:45:01 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[supt_ImportErrors](
	[Id] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[ProcessID] [nvarchar](100) NOT NULL,
	[RecordNbr] [int] NOT NULL,
	[Message] [nvarchar](100) NOT NULL,
	[DateTimeProcessed] [datetime] NOT NULL,
 CONSTRAINT [PK_supt_ImportErrors] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO