"Bill Mitchell" <bill.mitchell@jjindustries.com> wrote in message
news:u5M5LEDREHA.1340@TK2MSFTNGP12.phx.gbl...
> I have merge replication set up on several database tables. I was reading
> about using sp_repladdcolumn and sp_repldropcolumn to make modification to
> the schema since it cannot be done directly with the alter table command.
>
> However, I cannot find either of these store procedures in the list for
this
> database. I do see several sp_ followed by a long cryptic looking name
> comprised of lettes and numbers.
>
> Should the sp_repldropcolumn and sp_repladdcolumn be showing up on a merge
> replicated database? If so, do you know of why these are not showing up?
>
> Thanks,
> Bill Mitchell
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:u3qr33EREHA.2716@tk2msftngp13.phx.gbl...
> they are in the master database on all SQL Server 2000 systems.
> "Bill Mitchell" <bill.mitchell@jjindustries.com> wrote in message
> news:u5M5LEDREHA.1340@TK2MSFTNGP12.phx.gbl...
> > I have merge replication set up on several database tables. I was
reading
> > about using sp_repladdcolumn and sp_repldropcolumn to make modification
to
> > the schema since it cannot be done directly with the alter table
command.
> >
> > However, I cannot find either of these store procedures in the list for
> this
> > database. I do see several sp_ followed by a long cryptic looking name
> > comprised of lettes and numbers.
> >
> > Should the sp_repldropcolumn and sp_repladdcolumn be showing up on a
merge
> > replicated database? If so, do you know of why these are not showing
up?
> >
> > Thanks,
> > Bill Mitchell
> >
> >
>
>