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
You can get the published article from sys.dm_repl_articles (Transact-SQL) Select *From sys.dm_repl_articles Madhu
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