I thought I'd post this in the DTS forum as the others seemed a bit less appropriate. I've been setting up Replication Publications over the past few days and have hit a snag on the last one.
I'm setting up a Transactional Publication on all tables in a db which have primary keys. I've not run across any problems until now -- there is one table which has a primary key that is not available in the table list of articles to create. I have set the NOT FOR REPLICATION flag on the IDENTITY column in the table in question. I have two other tables with the same exact schema which I can set up for transactional publication just fine. Here is the schema for the table in question:
CREATE TABLE [dbo].[BestViewAM] (
[RecordID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[ExpenseDate] [smalldatetime] NULL ,
[RCC] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SBCUID] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PercentMgmtHC] [decimal](5, 4) NOT NULL ,
[PercentNonMgmtHC] [decimal](5, 4) NOT NULL ,
[PercentRespMgmt] [decimal](5, 4) NOT NULL ,
[PercentRespNonMgmt] [decimal](5, 4) NOT NULL ,
[MgmtWages] [int] NOT NULL ,
[MgmtWagesAdj] [decimal](5, 4) NOT NULL ,
[NonMgmtWages] [int] NOT NULL ,
[NonMgmtWagesAdj] [decimal](5, 4) NOT NULL ,
[Plant] [int] NOT NULL ,
[PlantAdj] [decimal](5, 4) NOT NULL ,
[Benefits] [int] NOT NULL ,
[BenefitsAdj] [decimal](5, 4) NOT NULL ,
[IncurredFleet] [int] NOT NULL ,
[IncurredFleetAdj] [decimal](5, 4) NOT NULL ,
[FleetCapital] [int] NOT NULL ,
[FleetCapitalAdj] [decimal](5, 4) NOT NULL ,
[ExemptMaterials] [int] NOT NULL ,
[ExemptMaterialsAdj] [decimal](5, 4) NOT NULL ,
[OtherMaterials] [int] NOT NULL ,
[OtherMaterialsAdj] [decimal](5, 4) NOT NULL ,
[Locates] [int] NOT NULL ,
[LocatesAdj] [decimal](5, 4) NOT NULL ,
[Proceeds] [int] NOT NULL ,
[ProceedsAdj] [decimal](5, 4) NOT NULL ,
[Rents] [int] NOT NULL ,
[RentsAdj] [decimal](5, 4) NOT NULL ,
[OtherContracts] [int] NOT NULL ,
[OtherContractsAdj] [decimal](5, 4) NOT NULL ,
[ConfTravel] [int] NOT NULL ,
[ConfTravelAdj] [decimal](5, 4) NOT NULL ,
[HomeRelo] [int] NOT NULL ,
[HomeReloAdj] [decimal](5, 4) NOT NULL ,
[Training] [int] NOT NULL ,
[TrainingAdj] [decimal](5, 4) NOT NULL ,
[Accidents] [int] NOT NULL ,
[AccidentsAdj] [decimal](5, 4) NOT NULL ,
[Awards] [int] NOT NULL ,
[AwardsAdj] [decimal](5, 4) NOT NULL ,
[Clearances] [int] NOT NULL ,
[ClearancesAdj] [decimal](5, 4) NOT NULL ,
[Computers] [int] NOT NULL ,
[ComputersAdj] [decimal](5, 4) NOT NULL ,
[OCS] [int] NOT NULL ,
[OCSAdj] [decimal](5, 4) NOT NULL ,
[Corporate] [int] NOT NULL ,
[CorporateAdj] [decimal](5, 4) NOT NULL ,
[Custom] [int] NOT NULL ,
[CustomAdj] [decimal](5, 4) NOT NULL ,
[Tier] [int] NOT NULL ,
[TierAdj] [decimal](5, 4) NOT NULL ,
[Legal] [int] NOT NULL ,
[LegalAdj] [decimal](5, 4) NOT NULL ,
[OtherMisc] [int] NOT NULL ,
[OtherMiscAdj] [decimal](5, 4) NOT NULL ,
[GrandTot] [int] NOT NULL ,
[TotWages] [int] NOT NULL ,
[TotNonLabor] [int] NOT NULL ,
[DateAdded] [smalldatetime] NOT NULL ,
[DateModified] [smalldatetime] NULL ,
[AddedBy] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UpdatedBy] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Since I had two other tables replicate with no issue, I decided to copy this table to a table with the same schema but a different name -- same problem. Does anyone have an idea what could be the issue here?
I'm setting up a Transactional Publication on all tables in a db which have primary keys. I've not run across any problems until now -- there is one table which has a primary key that is not available in the table list of articles to create. I have set the NOT FOR REPLICATION flag on the IDENTITY column in the table in question. I have two other tables with the same exact schema which I can set up for transactional publication just fine. Here is the schema for the table in question:
CREATE TABLE [dbo].[BestViewAM] (
[RecordID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[ExpenseDate] [smalldatetime] NULL ,
[RCC] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SBCUID] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PercentMgmtHC] [decimal](5, 4) NOT NULL ,
[PercentNonMgmtHC] [decimal](5, 4) NOT NULL ,
[PercentRespMgmt] [decimal](5, 4) NOT NULL ,
[PercentRespNonMgmt] [decimal](5, 4) NOT NULL ,
[MgmtWages] [int] NOT NULL ,
[MgmtWagesAdj] [decimal](5, 4) NOT NULL ,
[NonMgmtWages] [int] NOT NULL ,
[NonMgmtWagesAdj] [decimal](5, 4) NOT NULL ,
[Plant] [int] NOT NULL ,
[PlantAdj] [decimal](5, 4) NOT NULL ,
[Benefits] [int] NOT NULL ,
[BenefitsAdj] [decimal](5, 4) NOT NULL ,
[IncurredFleet] [int] NOT NULL ,
[IncurredFleetAdj] [decimal](5, 4) NOT NULL ,
[FleetCapital] [int] NOT NULL ,
[FleetCapitalAdj] [decimal](5, 4) NOT NULL ,
[ExemptMaterials] [int] NOT NULL ,
[ExemptMaterialsAdj] [decimal](5, 4) NOT NULL ,
[OtherMaterials] [int] NOT NULL ,
[OtherMaterialsAdj] [decimal](5, 4) NOT NULL ,
[Locates] [int] NOT NULL ,
[LocatesAdj] [decimal](5, 4) NOT NULL ,
[Proceeds] [int] NOT NULL ,
[ProceedsAdj] [decimal](5, 4) NOT NULL ,
[Rents] [int] NOT NULL ,
[RentsAdj] [decimal](5, 4) NOT NULL ,
[OtherContracts] [int] NOT NULL ,
[OtherContractsAdj] [decimal](5, 4) NOT NULL ,
[ConfTravel] [int] NOT NULL ,
[ConfTravelAdj] [decimal](5, 4) NOT NULL ,
[HomeRelo] [int] NOT NULL ,
[HomeReloAdj] [decimal](5, 4) NOT NULL ,
[Training] [int] NOT NULL ,
[TrainingAdj] [decimal](5, 4) NOT NULL ,
[Accidents] [int] NOT NULL ,
[AccidentsAdj] [decimal](5, 4) NOT NULL ,
[Awards] [int] NOT NULL ,
[AwardsAdj] [decimal](5, 4) NOT NULL ,
[Clearances] [int] NOT NULL ,
[ClearancesAdj] [decimal](5, 4) NOT NULL ,
[Computers] [int] NOT NULL ,
[ComputersAdj] [decimal](5, 4) NOT NULL ,
[OCS] [int] NOT NULL ,
[OCSAdj] [decimal](5, 4) NOT NULL ,
[Corporate] [int] NOT NULL ,
[CorporateAdj] [decimal](5, 4) NOT NULL ,
[Custom] [int] NOT NULL ,
[CustomAdj] [decimal](5, 4) NOT NULL ,
[Tier] [int] NOT NULL ,
[TierAdj] [decimal](5, 4) NOT NULL ,
[Legal] [int] NOT NULL ,
[LegalAdj] [decimal](5, 4) NOT NULL ,
[OtherMisc] [int] NOT NULL ,
[OtherMiscAdj] [decimal](5, 4) NOT NULL ,
[GrandTot] [int] NOT NULL ,
[TotWages] [int] NOT NULL ,
[TotNonLabor] [int] NOT NULL ,
[DateAdded] [smalldatetime] NOT NULL ,
[DateModified] [smalldatetime] NULL ,
[AddedBy] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UpdatedBy] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Since I had two other tables replicate with no issue, I decided to copy this table to a table with the same schema but a different name -- same problem. Does anyone have an idea what could be the issue here?