sp_repldropcolumn question -- sql server replication

GC
3/28/2006 8:06:02 AM

Hi,

I dont understand why when we drop a column we dont have to mention in which
publication we want to drop a column

We have to mention in which table but not in which publication
So if we have 2 differents publications in 2 different database
and in each database we have a table tEmploye that have the column firstname

If we want to drop the column firstname of the table tEmploye
in which publication this will be done

If we want to add a column we have to mention in which publication and
table we want to add the new column

Thank you in advance!

Vijay TS
3/28/2006 12:36:03 PM

When you drop a column with sp_repldropcolumn you cannot specify the
publication because if the column is dropped from the table it is not
available to either publication. If your intent is to remove the column from
a specific publication, you should be using sp_mergearticlecolumn stored
procedure.
--
â€œThis posting is provided "AS IS" with no warranties, and confers no rights.â€

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : sp_repldropcolumn question