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 not starting properly

I have MSDE come up when my system boots, but the server name does not appear
in the 1st dropdown box. So, I have to type the server name in and click the
start button in the MSDE window to get it to come up. I just want it to
start at boot-up, and be there without having to type the server name in
every time. Help.
You have the following options:
1. Add the following statement to Win.ini
Run = "SCM -Action 1 -Service mssqlserver -Silent"
2. Run the following in DOS:
REM modify SCM
SCM -Action 7 -Service mssqlserver -SvcStartType 2 -Silent
REM start sql service now
SCM -Action 1 -Service mssqlserver -Silent
"Tom Nowak" <TomNowak@.discussions.microsoft.com> wrote in message
news:BB6F9956-3BD9-4B00-A332-A5D79EC1ABAB@.microsoft.com...
> I have MSDE come up when my system boots, but the server name does not
appear
> in the 1st dropdown box. So, I have to type the server name in and click
the
> start button in the MSDE window to get it to come up. I just want it to
> start at boot-up, and be there without having to type the server name in
> every time. Help.