Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Cannot insert the value NULL into column 'rowguid'

Author  Topic 

roel_vz
Starting Member

16 Posts

Posted - 2008-05-19 : 06:13:52
I'm using SQL Server 2005 and have merge replication with 1 publisher and 9 subscribers.

When I try to add a record to a publisher table I get the following error from time to time (sometimes it works fine, sometimes it doesn't):
Cannot insert the value NULL into column 'rowguid'

The rowguid column has the following properties:
Data type: uniqueidentifier
Default Value or Binding: (newsequentialid())
Allow Nulls: no

Replication is running fine for the rest.

Here I have some logging and as you can see the rowguid column is not in the insert statement: http://www.tronk.be/server.log

Any help or comments are very much appreciated. Thanks in advance.
   

- Advertisement -