Re: Two Way Bidirectional Rep
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 4 Jan 2006 22:43:56 -0500
Ummm..I don't think so.
create table test
(pk int, charcol char)
go
insert into test values(1,'a')
go
(1 row(s) affected)
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael Hotek" <mike@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uNrzGhaEGHA.1816@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>>
>>
>>
>>
>>
>>
>
>
.
- Follow-Ups:
- Re: Two Way Bidirectional Rep
- From: Michael Hotek
- Re: Two Way Bidirectional Rep
- References:
- Re: Two Way Bidirectional Rep
- From: Michael Hotek
- Re: Two Way Bidirectional Rep
- Prev by Date: Re: Two Way Bidirectional Rep
- Next by Date: Re: distribution clean up job fail
- Previous by thread: Re: Two Way Bidirectional Rep
- Next by thread: Re: Two Way Bidirectional Rep
- Index(es):
Relevant Pages
|
