SQL Server Performance

Column 'rowguid' in table is invalid for creating a default constraint

Discussion in 'SQL Server 2008 Replication' started by sqlguy, Jun 22, 2011.

  1. sqlguy New Member


    I have a merge replication publication on a SQL 2008 R2 CU3 machine I am trying to replicate to a subscriber that is same SQL version.

    When I create publication ,all is fine. When I run the subscription the first time to blank subscriber database, all is fine. When I try and run it a second time, I get the error below. I use the option in the article of "Keep existing object unchanged". The idea is that should the link between publisher and subscriber fail, all data entered on Subscriber database ( which runs a web site ) will be merged back to the publisher once the link is back up.
    The table is tiny - it has one column of 10 rows of plain text data of datatype nchar(10) and no keys or contraints of any sort.

    Error messages I get when I attempt to start replication :

    The schema script 'Table_1_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
    Get help: http://help/MSSQL_REPL-2147201001
    Column 'rowguid' in table 'Table_1' is invalid for creating a default constraint. (Source: MSSQLServer, Error number: 1752)
    Get help: http://help/1752
    Could not create constraint. See previous errors. (Source: MSSQLServer, Error number: 1750)
    Get help: http://help/1750

    Just wondering if any knows what might be causing this - I have searched the net and nothing seems to be able to provide a solution.
    Thanks in advance,

  2. satya Moderator

    Can you attempt the snapshot again to see if it suceeds?

Share This Page