replication table

• RubySWorld

  SSCommitted

  Points: 1777

  More actions

  February 28, 2008 at 3:23 pm

  #187135

  How can we identify the number or the names of the tables that are involved in transactional replication in sql server 2000 ?

  Is there any perticulare commands or query that I can use to identify them caz i got a request to create a separate table which will have

  the names of the tables that are involved in replication in that database and also to create another separate table that will include tables

  that are not involved in the replication.

  Any suggestions

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 28, 2008 at 3:32 pm

  #783486

  If you have snapshot or transactional replication, you may try,

  sp_helparticle 'replicationName'

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  March 5, 2008 at 3:48 am

  #785388

  Hi,

  I think the best way would be to query the tables in the Distribution database.

  MSArticles contains all tables used in all the publishers on that server, you can join in MSPublications to get a more user friendly set of records

  To start

  USE Distribution

  SELECT Publication_id,Article

  FROM MSArticles

  ORDER By Publication_id

  HTH

  Graeme