Tuesday, February 21, 2012

Replication Issue

*** Apologies for the post in multiple newsgroup ***
Dear All
We have a publication on Server 1, using Transactional
Replication. Server 2 has the distribution database, and
the database we are replicating too.
We switched off the publication using EM Tools ->
Replication -> Disable Publication and Distribution, and
attempted to change some columns on Server 1, and recieved
a cannot change column as used in replication message.
I have tried a range of sql commands with no luck.
Can anyone sugest to me a way of going forward on this ?
Thanks
JThanks this has been solved.
>--Original Message--
>*** Apologies for the post in multiple newsgroup ***
>Dear All
>We have a publication on Server 1, using Transactional
>Replication. Server 2 has the distribution database, and
>the database we are replicating too.
>We switched off the publication using EM Tools ->
>Replication -> Disable Publication and Distribution, and
>attempted to change some columns on Server 1, and
recieved
>a cannot change column as used in replication message.
>I have tried a range of sql commands with no luck.
>Can anyone sugest to me a way of going forward on this ?
>Thanks
>J
>.
>

No comments:

Post a Comment