Very Computer

by **Iain Wardl** » Thu, 10 May 2001 00:20:48

Hi all,

I am using SQL server 7.0 sp2. What I am doing is Merge replication of a
database with one subscriber. The database has an Identity column on one of
the tables, the publisher and subscriber have different range values for
inserts with the 'Not For Replication' option set. eg. Publisher 1-50000,
Subscriber 50001-10000, this works fine with the insert on either side
updating the correct identity values. However, when I use a update the

the publisher it works fine but the subscriber always returns 0. I have had
a quick look at the Triggers placed on each table but they are exactly the
same. Anyone else ever come across this problem?? And perhaps have a
solution??

Thanks

Iain Wardle

by **Michael Hote** » Thu, 10 May 2001 07:21:55

It's a known issue between triggers and identities. I can't remember if it
was fixed in a 7.0 service pack or if the fix went into SQL Server 2000.

--
Please post all replies to newsgroups unless specifically stated otherwise.

SQL Server MVP
http://www.mssqlserver.com
"Aim high. You can never achieve more than you aspire to." - Al Ries

Very Computer

Merge Replication and Identity Problems on Subscribers

Merge Replication and Identity Problems on Subscribers

Merge Replication and Identity Problems on Subscribers