SQL Server Performance Forum – Threads Archive

Replication Knowledge

If 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…
MohammedU.
Moderator
SQL-Server-Performance.com

Try this one as well.. for all publication and respective table name details <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> select sp.[name] as ‘PublicationName’, sp.[description] as ‘Description of Publication’, sa.[name] as ‘TableName’ from sysarticles sa (nolock) join syspublications sp (nolock) on sa.pubid=sp.pubid order by sp.pubid, sa.[name] Deepak Kumar MVP, MCDBA – SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.

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
http://www.SQL-Server-Performance.Com
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

]]>