Re: Two Way Bidirectional Rep
- From: CLM <CLM@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Jan 2006 08:05:04 -0800
I don't know why it says that. My INSERT statement is correct and does
correctly insert a row into the table, i.e. I can look at the record after I
inserted it. The problem is that when it goes to push it over to the other
server, it fails.
"Michael Hotek" wrote:
> Take a look at the insert statement.
>
> You are saying: "insert into table values(...)". You MUST do the following:
> "insert into table (column list) values(...)"
>
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
>
> "CLM" <CLM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:5172165E-88AE-455F-8051-CBBBEB8936DA@xxxxxxxxxxxxxxxx
> >I implemented the above between 2000 two servers according to the following
> > link :
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;820675
> > I am just testing on one table and put in NOT FOR REPLICATION on both
> > servers according to the following:
> >
> > CREATE TABLE [dbo].[tbl_IssueTracker_IssueCategories] (
> > [category_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
> > [name] [varchar] (100) NOT NULL ,
> > [parent_category_id] [int] NOT NULL ,
> > [msrepl_tran_version] [uniqueidentifier] NOT NULL
> > ) ON [PRIMARY]
> > GO
> >
> > ALTER TABLE [dbo].[tbl_IssueTracker_IssueCategories] WITH NOCHECK ADD
> > CONSTRAINT [PK_tbl_IssueTracker_IssueCategories] PRIMARY KEY CLUSTERED
> > (
> > [category_id]
> > ) ON [PRIMARY]
> > GO
> >
> > ALTER TABLE [dbo].[tbl_IssueTracker_IssueCategories] ADD
> > CONSTRAINT [DF__tbl_Issue__msrep__6C39D5A3] DEFAULT (newid()) FOR
> > [msrepl_tran_version]
> > GO
> >
> > alter table tbl_IssueTracker_IssueCategories
> > with nocheck add constraint category_id_range2 check NOT FOR REPLICATION
> > ( category_id BETWEEN 10001 and 20000 )
> > go
> >
> > The problem is that I get the following error when I insert a record into
> > ServerA that is supposed to copy over to ServerB:
> >
> > "An explicit value for the identity column in table
> > 'tbl_IssueTracker_IssueCategories' can only be specified when a column
> > list
> > is used and IDENTITY_INSERT is ON."
> > and
> > "insert into "tbl_IssueTracker_IssueCategories" values (7, 'name1', 20,
> > {71A73DA7-1280-434C-9EB8-472487E724A4})
> > Transaction sequence number and command ID of last execution batch are
> > 0x000002B900000102000700000000 and 1."
> >
> > From what I understand, IDENTITY_INSERT is "on" if I put NOT FOR
> > REPLICATION, so I don't understand what the problem is.
> >
> >
> >
> >
> >
> >
>
>
>
.
- References:
- Re: Two Way Bidirectional Rep
- From: Michael Hotek
- Re: Two Way Bidirectional Rep
- Prev by Date: Re: Peer to peer replication on SQL 2000?
- Next by Date: Re: Two Way Bidirectional Rep
- Previous by thread: Re: Two Way Bidirectional Rep
- Next by thread: Re: Two Way Bidirectional Rep
- Index(es):
Relevant Pages
|
Loading
