I goofed about a year ago when I created a table without a primary key set. The full table is now an article in a merge publication. I am now having issues with using it as a data service and I want to correct it.
Management Studio warns me about a validation error if I try and add a primary key to the table:
- Error validating the default for column 'rowguid'.
Is there an easy way to fix this or do I need cancel replication, fix the table, then republish?
BTW, it is SQL 2008 Workgroup Edition