What are the correct steps to alter a PK column of a table that is a merge replication source in SQL SVR 2005?

You cant change a primary key on a published table as its part of the system used to push the data around ; so remove the table from the publication; make the changes and republish it.

You cant change a primary key on a published table as its part of the system used to push the data around ; so remove the table from the publication; make the changes and republish it. You can drop your table using sp_droparticle msdn.microsoft.com/en-us/library/ms17383... Then make your table / your key changes Finally use sp_addmergearticle to add it back in msdn.microsoft.com/en-us/library/ms17432....

Looks like you can't drop it from the publication if there is a subscription to it according to the link for sp_droparticle. Thanks, though. – Zack Apr 29 '09 at 17:55 I removed the article from the publication and modified it.

Then added it back. The subscriber has to re initlize from the snapshot. – Zack Apr 29 '09 at 21:11 Excellent, hope its a small database with a few subscribers :) – u07ch Apr 29 '09 at 21:28.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.