Re: "Hidden" Replication Stored Procedures?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Just make a copy of the database files, attach it with a different name
and... 'voila'!

:-)

Chris wrote:
Great, that was exactly what I was looking for and when opening the
aforementioned MDF file in Notepad and doing a quick search, I found the SPs
I had mentioned in my earlier post. Thanks for the good info!

I have one follow up question based on your answer:
Is there a way to have the Resource Database appear in the list of Databases
in SQL Server Management Studio for easy browsing of it's contents, or is the
only browse option to open the MDF file with a text editor such as notepad?

--
Thanks.

Chris Jones
Application Development Consultant


"Hilary Cotter" wrote:

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: Limitations using Developer
    ... Chris, thanks for the response. ... > The packaging wizard is just what you use to install it. ... >> packaging wizard once to get a database to a user who didn't ...
    (microsoft.public.access.devtoolkits)
  • Re: Access cant open the file "image.jpg"????
    ... Chris K wrote: ... I'm not sure how developers get on with Access spending so much time ... reconnecting report backgrounds, mail merges, and tables every time ... developing the database on different machines and the image is ...
    (microsoft.public.access.reports)
  • Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
    ... In Visual C# Express, I created a windows application, then "Added" a ... Doing this created an MDF file in my project folder, ... database into my database explorer window in the IDE. ... It would seem with this option, then one could use a SQL Server MDF ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Microsoft DevDays 2004 - Smart Client 3 - Security session
    ... listening to the webcast again and I found the transcript. ... See I've gone and decrypted my database credentials, ... Thanks again Chris. ... > probably talking about using IPSEC between the app server and database ...
    (microsoft.public.sqlserver.security)
  • Re: [PHP] method to prevent multiple logons of same account
    ... > Chris W. Parker wrote: ... >> the second login attempt. ... >> in the database. ... with the membership system which logs the user out once the ...
    (php.general)