Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't create Transactional Publication

Status
Not open for further replies.

ks1392

Programmer
Dec 7, 2001
63
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top