MSDE publisher and subscriber with duplicated Identity column issues

I am new to SQL replication and I have an issue with the identity
column not properly synchronizing between two MSDE databases. I have
turned on the (not for replication) switch and changed the identity
seed and identity increment to be different on the subscriber, but as
soon as I pull the subscription it changes the seed back to the
original so both database are the same again. As both subscriber and
publisher are creating records, the identities are duplicated. I do
have Enterprise Manager installed to help configure the publishing,
but MSDE does not seem to allow the same control over the identity
range in replication as SQL 2000 does. How do I have a MSDE publisher
and a MSDE subscriber create records in different identity seeds
and/or increment?
What I am trying to accomplish:
Publisher -- seed 1, increment 2
Subscriber -- seed 2, increment 2
Or a similar function.
Thanks,
Daniel
Are you using replication's auto identity management feature. In SQL
identitites once a table is created you cannot change the identity increment
or the original seed. The only thing you can do is reseed to a value and SQL
with start inserting from that value onwards.
Thanks.
"Daniel" <dmaynes@.roinc.com> wrote in message
news:5ab2240f.0410061403.3923ef4a@.posting.google.c om...
> I am new to SQL replication and I have an issue with the identity
> column not properly synchronizing between two MSDE databases. I have
> turned on the (not for replication) switch and changed the identity
> seed and identity increment to be different on the subscriber, but as
> soon as I pull the subscription it changes the seed back to the
> original so both database are the same again. As both subscriber and
> publisher are creating records, the identities are duplicated. I do
> have Enterprise Manager installed to help configure the publishing,
> but MSDE does not seem to allow the same control over the identity
> range in replication as SQL 2000 does. How do I have a MSDE publisher
> and a MSDE subscriber create records in different identity seeds
> and/or increment?
> What I am trying to accomplish:
> Publisher -- seed 1, increment 2
> Subscriber -- seed 2, increment 2
> Or a similar function.
> Thanks,
> Daniel
|||I guess this is a newbi question, but how and when do I turn that on?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Daniel,
when you create the publication, on the article properties (the elipsis
button) there is a series of tabs, one called 'identity range'. The checkbox
at the top allows for automatic range management. Some people don't use it
and prefer to roll their own, using formulas like odds on the publisher and
evens on the subscriber.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Right, I found that. I guess the trick is that it has to be checked as
you build the publication, and can be modified, but not added
afterwards. Thank you very much.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

MSDE names instance as Replication publisher?

I'm trying to setup a named instance of MSDE on my local machine, as a
Replication Publisher and I always get an error. My named instance is called
"MSDE"
Error 18483: Could not connect to server 'mymachine\msde' because
'distributor_admin' is not defined as a remote login at the server.
The only remote thing I can find on the MS support site is:
http://support.microsoft.com/default...;en-us;Q324992
but that really didn't help, since it was talking about IP addresses and not
named instances of MSDE.
Can anyone help me get this resolved?
FYI... i also found this article:
http://support.microsoft.com/default...b;en-us;818334
which talks about server names... when I look at the @.@.ServerName variable,
it returns my hostname and instance name: CORPDALL140451\MSDE
is that the problem? I already have a SQL Server instance with no name
running on my machine, but I must have this MSDE instance be the replication
publisher.
"Derick Bailey" <DerickBailey@.srcp.com> wrote in message
news:eR7q4xUtEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I'm trying to setup a named instance of MSDE on my local machine, as a
> Replication Publisher and I always get an error. My named instance is
> called "MSDE"
> Error 18483: Could not connect to server 'mymachine\msde' because
> 'distributor_admin' is not defined as a remote login at the server.
> The only remote thing I can find on the MS support site is:
> http://support.microsoft.com/default...;en-us;Q324992
> but that really didn't help, since it was talking about IP addresses and
> not named instances of MSDE.
> Can anyone help me get this resolved?
>