Newbie Needs Help ;)

Thanks everyone (especially Hilary) for your help.
Apologies for not saying earlier but I left for home for
the weekend (I'm in the UK).
The Replication I set up was from the Microsoft Web page,
can anyone tell me of a guide on 'What to do when things
go wrong ?'
Peter

>--Original Message--
>Hello,
>I'm new to replication. I have got a subscriber,
publisher
>ans distributer working ok, so now does the snapshot
>replication, then the transactional ones.
>It was working fine for 5 minutes then I had the
following
>error
>Cannot update identity column 'ID'.
>{CALL sp_MSupd_tblPerson
>
(NULL,0,NULL,NULL,NULL,NULL,NULL,' ',1,0,7146,0x82
>03)}
>ID is a primary key with an Identity setting get to 'Yes
>but not for replication'.
>Any pointers please
>Peter
>.
>
Peter,
I think the best thing to do is to search this newsgroup. I maintain a short
list of things I have found useful at www.replicationanswers.com which is
not meant to be exhaustive.
There are one or two other articles around that may help:
http://www.microsoft.com/technet/pro.../mergproc.mspx
http://www.databasejournal.com/featu...le.php/1468971
HTH,
Paul Ibison
|||Thanks Paul

>--Original Message--
>Peter,
>I think the best thing to do is to search this newsgroup.
I maintain a short
>list of things I have found useful at
www.replicationanswers.com which is
>not meant to be exhaustive.
>There are one or two other articles around that may help:
>http://www.microsoft.com/technet/pro.../sql/2000/main
tain/mergproc.mspx
>http://www.databasejournal.com/featu...l/article.php/
1468971
>HTH,
>Paul Ibison
>
>.
>