replication conflict how do I remove them

  • CREATE TABLE [conflict_jlinknew1_Accounting] (

    [ID] [int] NOT NULL ,

    [Username] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [NASID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [NASPort] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [FramedIPAddress] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [CallingStationID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctStatusType] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctDelayTime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctInputOctets] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctOutputOctets] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctSessionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctAuthentic] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctSessionTime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctInputPackets] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctOutputPackets] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctTerminateCause] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctMultiSessionID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [AcctLinkCount] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [TimeStamp] [datetime] NOT NULL ,

    [rowguid] uniqueidentifier ROWGUIDCOL NOT NULL ,

    [origin_datasource] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [conflict_type] [int] NULL ,

    [reason_code] [int] NULL ,

    [reason_text] [nvarchar] (720) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [pubid] [uniqueidentifier] NULL ,

    [create_time] [datetime] NOT NULL CONSTRAINT [DF__conflict___creat__592E273E] DEFAULT (getdate())

    ) ON [PRIMARY]

    GO

    CREATE TABLE [conflict_jlinknew1_achexport] (

    [last_run] [datetime] NOT NULL ,

    [ach_banknumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

    [ach_accountnumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

    [rowguid] uniqueidentifier ROWGUIDCOL NOT NULL ,

    [msrepl_tran_version] [uniqueidentifier] NOT NULL ,

    [origin_datasource] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [conflict_type] [int] NULL ,

    [reason_code] [int] NULL ,

    [reason_text] [nvarchar] (720) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [pubid] [uniqueidentifier] NULL ,

    [create_time] [datetime] NOT NULL CONSTRAINT [DF__conflict___creat__528129AF] DEFAULT (getdate())

    ) ON [PRIMARY]

    GO

    CREATE TABLE [conflict_jlinknew1_achexport_old] (

    [last_run] [datetime] NULL ,

    [ach_banknumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [ach_accountnumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [rowguid] uniqueidentifier ROWGUIDCOL NOT NULL ,

    [origin_datasource] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [conflict_type] [int] NULL ,

    [reason_code] [int] NULL ,

    [reason_text] [nvarchar] (720) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

    [pubid] [uniqueidentifier] NULL ,

    [create_time] [datetime] NOT NULL CONSTRAINT [DF__conflict___creat__4BD42C20] DEFAULT (getdate())

    ) ON [PRIMARY]

    GO

  • I don't understand your question. If you mean how to resolve conflicts, use the Replication Conflict Viewer utility. Right-click on the database in EM and choose All Tasks | View Replication Conflicts...

    Jay Madren


    Jay Madren

  • Is this a question about merge replication conflicts?

  • Is this a question about merge replication conflicts?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply