January 23, 2004 at 1:48 pm
I'm new to replication. It appears that when I create a publication and subscriber this works fine, but it will not allow me to change a published article, i.e. change a column name or length, etc. I see you can add or delete a column from a published article under the publication properties, but how can you make a change to a column like, changing its name? I saw on some message board someone mentioned a stored procedure for this. Does anyone know what that is, and how to use it or an example? Or is there another way to do this? Please HELP!!! Thanks in advance for any suggestions.
-Pat
January 23, 2004 at 2:07 pm
January 23, 2004 at 2:30 pm
thanks. When I go to make changes to the MSins and MSupd sp's it gives me "invalid column name error" when I try to change the column name. It won't accept the changes. Am I doing something wrong? Thanks.
-Pat
January 23, 2004 at 2:58 pm
Did you complete step 1- 3?
This procedure has been practiced lot of times, it shouldn't have problem.
Good luck!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply