Can You Tell Me Some Of The Common Replication Dmv's And Their Use?

1.	Can You Tell Me Some Of The Common Replication Dmv's And Their Use?
Answer» sys.dm_repl_articles - Contains INFORMATION about each article being published. It RETURNS data from the DATABASE being published and returns a row for each object being published in each article. sys.dm_repl_schemas - Contains information about each table and column being published. It returns data from the database being published and returns ONE row for each column in each object being published. sys.dm_repl_traninfo - Contains information about each transaction in a TRANSACTIONAL replication.

Answer»

sys.dm_repl_articles - Contains INFORMATION about each article being published. It RETURNS data from the DATABASE being published and returns a row for each object being published in each article.
sys.dm_repl_schemas - Contains information about each table and column being published. It returns data from the database being published and returns ONE row for each column in each object being published.
sys.dm_repl_traninfo - Contains information about each transaction in a TRANSACTIONAL replication.

Discussion