Generate sp_addsubscriber

Is there any way to generate a script for the subscribers of a publication? I
know you can generate scripts for the publication, the distribution database,
the replication jobs, but have not found anyplace where you can have EM
generate the SP_ADDSUBSCRIBER script.
Any help would be appreciated.
Thanks!
Add one subscriber, and then script out your publication. The required
commands will be at the end.
To add a new subscriber use sp_addsubscriber. You can't automatically
generate a new script for this, you have to manually add it.
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
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:78C831D3-521B-49DF-9AB0-6301EEC5D97C@.microsoft.com...
> Is there any way to generate a script for the subscribers of a
> publication? I
> know you can generate scripts for the publication, the distribution
> database,
> the replication jobs, but have not found anyplace where you can have EM
> generate the SP_ADDSUBSCRIBER script.
> Any help would be appreciated.
> Thanks!
|||Hilary:
Would you have an example of an sp_addsubscriber stored procedure call? I've
tried to capture the SQL via Profiler, but because of the password coulmn,
SQL Server masks the output...
Thanks You!!
"Hilary Cotter" wrote:

> Add one subscriber, and then script out your publication. The required
> commands will be at the end.
> To add a new subscriber use sp_addsubscriber. You can't automatically
> generate a new script for this, you have to manually add it.
> --
> 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
> "A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
> news:78C831D3-521B-49DF-9AB0-6301EEC5D97C@.microsoft.com...
>
>