SQL Server Performance Forum – Threads Archive
Replication KnowledgeIf I have hundreds of publications, Is there a View or table or stored procedure in SQL to find which table belong to which publication. Also how can I find all Publication list and articles list from query analyzer???
Check sysarticles system view…
SELECT * FROM SYSARTICLES also check "Replication Views (Transact-SQL) " topic in BOL…
Try this one as well.. for all publication and respective table name details <img src=’/community/emoticons/emotion-5.gif’ alt=’‘ /><br /><br /><br /><br />select sp.[name] as ‘PublicationName’, sp.[description] as ‘Description of Publication’, sa.[name] as ‘TableName’ from sysarticles sa (nolock)<br />join syspublications sp (nolock)<br />on sa.pubid=sp.pubid<br />order by sp.pubid, sa.[name]<br /><br /><b>Deepak Kumar</b><br /><font size="1">MVP, MCDBA – SQL Server<br /><br />Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</font id="size1">
From the heading of this post, I thought you are seeking articles & reference on replication, appreciate Mohammed & Deepak’s insight on replication (it helps). Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Thanks thats really helpfull. Cheers