SQL Server Performance

Transactional Replication Question

Discussion in 'Performance Tuning for SQL Server Replication' started by bgoldy, May 10, 2004.

  1. bgoldy New Member

    Does anyone know if there is a script that will query each replication subscription and return the schedule for SQL 2000?

    bgoldy
  2. satya Moderator

    To 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.
  3. bgoldy New Member

    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
  4. satya Moderator

    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.

Share This Page