Re: "Hidden" Replication Stored Procedures?

they are in mssqlsystemresource.mdf. Open it in a text editor to read what
this proc does.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:420DD987-9E55-46AB-8445-82FD01740996@xxxxxxxxxxxxxxxx
In looking thru the code for the replication related stored procedure
sp_addarticle, I noticed that there were 2 stored procedures called from
sp_addarticle that I can't seem to find anywhere on my SQL Server:
sys.sp_MSrepl_getpublisherinfo & sys.sp_MSrepl_addarticle. These are
stored
procedures that appear to be undocumented and I have read comments on
Microsoft sites stating things like: "Undocumented stored procedures are
only
for the use of internal replication components and should not be used to
administer replication.". I just want to know more about these stored
procs
(and others like these) as far as where they live, what they do, how
sp_addarticle calls these Stored Procs without the SP blowing up.....as I
have tried to call sys.sp_MSrepl_getpublisherinfo in a 10 line script I
made
and all I got back was that the sys.sp_MSrepl_getpublisherinfo couldn't be
found no matter what DB I tried to execute against. I don't see anything
helpful about these SPs when I Google (and I am a Google master) or
anywhere
else. If anyone has anything relevant & helpful, I would appreciate the
info.
--
Thanks.

Chris Jones
Application Development Consultant


.

Relevant Pages

  • Re: basic question
    ... Currently we have are doing calculations via stored procedures ... in which case *I* would like to have them run on the SQL server ... procs are doing. ...
    (microsoft.public.dotnet.general)
  • Re: Failed to enumerate changes in the filtered articles. Incorrect syntax near -.
    ... Looking for a SQL Server replication book? ... > that they will give you a patch. ... > dll's were patched successfully, system stored procedures also, and patch ...
    (microsoft.public.sqlserver.replication)
  • RE: insert, delete, update stored procedures in Snapshot
    ... Having SQL Server create two sets of replication stored procedures is an error. ... SQL Server will by default autogenerate stored procedures in the unbracketed form, ... > bracquets, the other without bracquets, e.g. ...
    (microsoft.public.sqlserver.replication)
  • Re: Urgent : SQL2000 replication question
    ... regenerate these stored procedures and will revert back to the original ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Another Sql Server -> Oracle Replication
    ... I have a question about stored procedures in Sql Server, when i will do replication from Sql Server to Oracle, what will happen with stored procedures, will they be replicated to along with tables and data? ... Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
    (microsoft.public.sqlserver.replication)
Loading