Friday, February 10, 2012

Cannot find sp_repladdcolumn stored procedure.

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
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
>
|||Thanks Hilary! I am just learning SQL Server and was sure I had corrupted
something in my database.
Bill
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:u3qr33EREHA.2716@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> 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...
reading[vbcol=seagreen]
to[vbcol=seagreen]
command.[vbcol=seagreen]
> this
merge[vbcol=seagreen]
up?
>

No comments:

Post a Comment