February 18, 2010 at 9:05 am
I have 2 SQL Server 2005 instances, one local, one remote. I have a table at the local instance that has a uniqueidentifier, with a default value of newid(). I would like to set up merge replication for this table so that I can replicate it to the remote server, so I did that. The reason is that the remote server supports a web app that allows new records to be created. But now when I try to add a new record thru the web app it fails with an error saying cannot insert NULL into the uniqueidentifier field. So I looked at the replicated table at the remote instance and found that the default value of newid() was not set. So I tried to set it and got an error saying error validating the default for the column rowguid. Anyone have any ideas what I should do?
February 18, 2010 at 11:51 am
SOLVED - apparently my existing uniqueidentifier field did NOT already have newid() set as the default value. I set that and recreated the Publication, and all is good now.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply