COMMUNITY FORUM

I assume you have Smart Connect installed and previously set up at this point, but if not, you should do that first.

If you do have Smart Connect installed, try creating the SC9001 table with the definition below.

USE [DYNAMICS]

GO

/****** Object: Table [dbo].[SC9001] Script Date: 06/19/2013 11:08:35 ******/

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SC9001](

[PRODID] [smallint] NOT NULL,

[Series_Number] [smallint] NOT NULL,

[TABLTECH] [char](79) NOT NULL,

[TBLPHYSNM] [char](51) NOT NULL,

[TABLDESC] [char](51) NOT NULL,

[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PKSC9001] PRIMARY KEY NONCLUSTERED

(

[PRODID] ASC,

[Series_Number] ASC,

[TABLTECH] 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

SET ANSI_PADDING OFF