February 21, 2009 at 12:29 pm
Hi All,
Today we have done some script changes on publisher, then we have done same script change on subscriber after that I am seeing the below
Error message
Replication-Replication Distribution Subsystem: agent failed. Procedure or function sp_MSupd_tblxyz has too many arguments specified.
Rajesh Kasturi
February 21, 2009 at 12:32 pm
What script changes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 21, 2009 at 1:40 pm
We had setup Transactional replication,
Today we have done the below changes
We supposed to do DDL Changes to the replicated tables so
1. Instead of removing the replication we
dropped the subscription to publication, Done DDL Changes on publisher and subscri.., again Added the subscriptions.
2. here publication gone, so we reinitilize the publication
3. While reiniti... pub we choosen the option to sync only data.
After couple of hours, replication stated failing
Rajesh Kasturi
February 21, 2009 at 1:45 pm
What DDL changes?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 23, 2009 at 12:35 am
DDL Changes were increasing the column length
Rajesh Kasturi
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply