Friday, February 24, 2012

Cannot insert the value NULL into column 'rowguid'....

Hello
i'm using merge replication in SQL server 2k but when i try to synchronise a
subscriber i get the following error
Cannot insert the value NULL into column 'rowguid'...
This seems to be caused by the fact that the columns are in a different
order
ie. columns we added after the publication
is there a way to cause the publication to name the fields in the insert
therefore eliminating this problem?
Thanks
How did you add the columns after the table was published?
Donna
"kris Palmby" wrote:

> Hello
> i'm using merge replication in SQL server 2k but when i try to synchronise a
> subscriber i get the following error
> Cannot insert the value NULL into column 'rowguid'...
> This seems to be caused by the fact that the columns are in a different
> order
> ie. columns we added after the publication
> is there a way to cause the publication to name the fields in the insert
> therefore eliminating this problem?
> Thanks
>
>
|||I'd like to know this also.
"Donna Lambert" <DonnaLambert@.discussions.microsoft.com> wrote in message
news:E4388B76-FBB2-4F00-8893-1F3F0ACEFB31@.microsoft.com...[vbcol=seagreen]
> How did you add the columns after the table was published?
> Donna
> "kris Palmby" wrote:

No comments:

Post a Comment