Login to access your account
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
SET ANSI_PADDING ON
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]
SET ANSI_PADDING OFF
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