find out replication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

find out replication

Author

Topic

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-03-13 : 23:36:04

How do you use t-sql to list subscribers, distributor, and publishers?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-14 : 17:26:36

Check BOL for the replication stored procedures. I wouldn't use T-SQL though as it is so easy via SSMS. I'm a huge fan of using T-SQL for most things, however not for replication.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-14 : 18:09:26

I agree with Tara. But, for the sake of completeness:

use distribution;

select * from dbo.MSpublications

select * from dbo.MSsubscriptions

select * from dbo.MSdistribution_agents

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2010-03-15 : 13:12:39

Thanks guys, I just found the SPs.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources