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.
| Author |
Topic |
|
sqlguy7777
Starting Member
14 Posts |
 Posted - 2011-06-23 : 02:22:15
|
| HowdyI 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-2147201001Column 'rowguid' in table 'Table_1' is invalid for creating a default constraint. (Source: MSSQLServer, Error number: 1752)Get help: http://help/1752Could 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,SG |
|
|
|
|
|
Column 'rowguid' in table is invalid for