list existing replication's settings

Hi experts,
I wish to document the replication settings on our
environment, is there a good way to list the settings on
the system ?
regards,
Diana.
Diana,
there are loads of sps to help with documentation:
sp_helpdistpublisher
sp_helpdistributor
sp_helppublication
sp_helpsubscription
to name but a few. Many of them take parameters, so you can't run them
without first configuring.
I personally do things in a less sophisticated way - I right-click the
replication folder and select "Generate SQL script..." which is then placed
in Sourcesafe.
You could also do this in SQLDMO, but IMO the simplest and quickest way
would be to have EM create the script as above.
HTH,
Paul Ibison
|||sp_helppublication provides much of the information you are looking for.
I also find it helpful to script out my replication jobs. Here is an example
of such a script.
set objServer=CreateObject("SQLDMO.SQLServer")
objServer.LoginSecure=True
objServer.Connect "Publisher"
objServer.Replication.Script 1024,"c:\sqlout.sql"
set objServer=Nothing
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Diana" <yuendiana@.sinaman.com> wrote in message
news:261301c47dfb$d68d8a40$a301280a@.phx.gbl...
> Hi experts,
> I wish to document the replication settings on our
> environment, is there a good way to list the settings on
> the system ?
> regards,
> Diana.