October 1, 2007 at 10:30 pm
Good day to all,
I'm just starting to explore and test the sql server replication. During initial replication, the synchronization work fine, but if there's already a change in the table and/or stored procedure in the publisher, the subscriber always gets an error message. as to what i understand so far, any changes in the publisher should be reflected to the subscriber after the subscriber synchronize. But why am I getting error if the table and/or sp is change (the sp and/or table name is maintained, only the table columns or the logic in the sp is change)? thanks in advance for all the help and information
Jay Jose
Jr. Web Developer
Retail Software Solutions
October 2, 2007 at 5:39 am
You gave us an "or" in your question that makes it difficult to answer, but here goes.
If you set up your publication to publish all columns in a table article, adding a column should have caused an error on your publisher unless you did the appropriate statements or used the replication UI to add the column. When done appropriately, replication can replicate a new column. Removal of a column is a different story and will force reinitialization.
If you modified a stored procedure, you may see in your replication monitory that it is complaining that a snapshot of the article is unavailable. You often have to run the snapshot agent to the stored procedure syntax can be replicated and the distribution agent will use this piece of the snapshot to send it to the subscriber.
With some additional information (specifically what you changed in yor schema and if you took all of the defaults, and what type of replication you are using), we could be of more help.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply