Identity

Hi Guru's
Our transactional replication is causing is problems with
our identity columns not being updated. I have followed
all the advice and zip nada ect.
So I was wondering if its possible to update the value
internally i,e, set the next identity to somthing.
Thanks for you time
RabbitHad the same problem. Fixed it by having the following
command in all the replication created insert scripts
DBCC CHECKIDENT, you can look up the rest on BOL
Peter
"Real knowledge is to know the extent of one's ignorance."
Confucius
>--Original Message--
>Hi Guru's
>Our transactional replication is causing is problems with
>our identity columns not being updated. I have followed
>all the advice and zip nada ect.
>So I was wondering if its possible to update the value
>internally i,e, set the next identity to somthing.
>Thanks for you time
>Rabbit
>.
>|||Thanks Pete
>--Original Message--
>Had the same problem. Fixed it by having the following
>command in all the replication created insert scripts
>DBCC CHECKIDENT, you can look up the rest on BOL
>Peter
>"Real knowledge is to know the extent of one's
ignorance."
>Confucius
>
>>--Original Message--
>>Hi Guru's
>>Our transactional replication is causing is problems
with
>>our identity columns not being updated. I have followed
>>all the advice and zip nada ect.
>>So I was wondering if its possible to update the value
>>internally i,e, set the next identity to somthing.
>>Thanks for you time
>>Rabbit
>>.
>.
>