SQL Server Performance Forum – Threads Archive
Transactional Replication Question
Does anyone know if there is a script that will query each replication subscription and return the schedule for SQL 2000? bgoldyTo script replication stored procedures, navigate to the replication/publications folder on the publisher. We right-click the desired publication and choose Generate SQL script. Choose Tools, Replication, Generate SQL Script on the distribution server, we get a slightly different dialog box that allows us to generate replication scripts as well. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I am VERY new to sql, so I may not be asking this question correctly. On the subscriber I can go to each database, pull subscriptions, double click on a subscription, click on the synchronization tab then click on distribution agent properties and look at the schedule tab to view the scheduled times for the pull. Is there a way to script this so that I will not have to look at 1700+ distribution agents to find out if they are scheduled properly? bgoldy
Run sp_helpdistributor & sp_helpsubscriberinfo for information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>