April 3, 2008 at 9:00 am
Hi,
I added a column to one table in a merge replication system. After the synchronization one computer updated the schema correctly but the other one stop the abort the process with the following error message:
Message
2008-04-03 14:50:14.912 Category:NULL
Source: Microsoft SQL Native Client
Number: 14013
Message: This database is not enabled for publication.
2008-04-03 14:50:14.974 Category:NULL
Source: Microsoft SQL Native Client
Number: 21530
Message: The schema change failed during execution of an internal replication procedure. For corrective action, see the other error message that accompany this error message.
2008-04-03 14:50:15.037 Category:NULL
Source: Microsoft SQL Native Client
Number: 3609
Message: The transaction ended in the trigger. The batch has been aborted.
2008-04-03 14:50:15.131 [100%] The process was successfully stopped.
2008-04-03 14:50:15.146 Category:NULL
Source: Merge Replication Provider
Number: -2147200963
Message: The process was successfully stopped.
April 5, 2008 at 10:23 pm
how did you add column? I am sure you have not used sp_repladdcolumn procedure to do this.
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 6, 2008 at 10:40 am
I used the Alter instruction that is supposed to be used in 2005. Now the DBA took that column out of the replication and the problem got worst because now both machines are not sincronizing at all...
April 6, 2008 at 12:33 pm
Remove problematic table from list of articles
generate create table script of table
re-create table on subscriber.. export data from publisher..
Add table in article list... start synchronizing...
[font="Verdana"]--www.sqlvillage.com[/size][/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply