Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication?

I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so but now it will not synchronize with the following error -->

Insert Error: Column name or number of supplied values does not match table definition. (Source: MSSQLServer, Error number: 213)

Add my comment below here for easier viewing

Yes the table change was already replicated. THEN the Stored PRocedure quit working as the columns were off so I did an ALTER on the stored procedure and tried to replicate that. Now it won't sync

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Has the table change been replicated yet? I'm not a replication expert but that might be your problem.

share|improve this answer
    
yes the table change was already replicated. THEN the Stored PRocedure quit working as the columns were off so I did an ALTER on the stored procedure and tried to replicate that. Now it won't sync...I am a dead man.... :( –  Refracted Paladin Mar 18 '10 at 14:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.