SQL Server Performance

how to find out what tables are being published using SQL query statement

Discussion in 'SQL Server 2008 Replication' started by WingSzeto, Aug 14, 2009.

  1. WingSzeto Member

    Is there a SQL statement that I can use to tell me if a table is being published or not? I know sp_helparticle can do the job but I need more control. What I like to do is to write a query which first detect if a table is published or not, if it is, remove them from the publisher and then delete the table. If someone has some idea on this, please share your code.
    Thank in advance,
    w
  2. madhuottapalam New Member

  3. WingSzeto Member

    Does this view only show articles that have been replicated changes? I have over 255 published articles but when I ran this view on our testing system, it only showed 25 records. If I ran it on our production system, it shows all published articles.
    W

Share This Page