Could not able to enable auto identity range, please help.

Hi there,
I am trying to publish database and replicate using merge replication.
Lot of my table have identity column which are pk as well. I crated
publication and it not giving me option to enable auto identity range
by sql server 2000 itself. could you please let me know what i need to
do so that server give me option to enable auto identity range
management option during initial pulication creation.
Please help me .
Thanks.
Indra.
Have you already created your Publication?
If so you can't do this by altering the publication/articles properties via
the EM.
open up Query Analyzer and do this
declare @.keyword varchar(250)
declare @.keyword2 varchar(250)
declare @.str nvarchar(2500)
set @.keyword='ringer'
set @.keyword2='green'
set @.str='select * from authors as a join containstable(authors,
*,''isabout('+char(34)+@.keyword +char(34)+' weight(.8),'
+char(34)+@.keyword2+char(34)+' weight(.7))'') as t on a.au_id=t.[key]'
exec (@.str)
in front of isabout there are two single quotes, same as by weight(.7))
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Indra" <itimilsina@.savannaenergy.com> wrote in message
news:e667cf1e.0407220804.11855f4b@.posting.google.c om...
> Hi there,
> I am trying to publish database and replicate using merge replication.
> Lot of my table have identity column which are pk as well. I crated
> publication and it not giving me option to enable auto identity range
> by sql server 2000 itself. could you please let me know what i need to
> do so that server give me option to enable auto identity range
> management option during initial pulication creation.
> Please help me .
> Thanks.
> Indra.
|||oops, scratch that - wrong newsgroup
I think you have to drop your publication and recreate it. When you get to
the specify articles dialog, click the browse button and go to the identity
range tab and make the changes there.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%23HuVUpBcEHA.2388@.TK2MSFTNGP11.phx.gbl...
> Have you already created your Publication?
> If so you can't do this by altering the publication/articles properties
via
> the EM.
> open up Query Analyzer and do this
> declare @.keyword varchar(250)
> declare @.keyword2 varchar(250)
> declare @.str nvarchar(2500)
> set @.keyword='ringer'
> set @.keyword2='green'
> set @.str='select * from authors as a join containstable(authors,
> *,''isabout('+char(34)+@.keyword +char(34)+' weight(.8),'
> +char(34)+@.keyword2+char(34)+' weight(.7))'') as t on a.au_id=t.[key]'
> exec (@.str)
> in front of isabout there are two single quotes, same as by weight(.7))
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Indra" <itimilsina@.savannaenergy.com> wrote in message
> news:e667cf1e.0407220804.11855f4b@.posting.google.c om...
>