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.
Author |
Topic |
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-07-07 : 17:01:01
|
Lets say, I have access to only distributor, can we findout the publisher and subcriber servers names |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-08 : 04:47:20
|
Yes, in the replication system tables, have a look at the tables and you will find it. |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2009-07-08 : 12:42:11
|
Kind of new to replication, if you can provide the system tables/query , it would be great. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-09 : 04:15:35
|
Here is a list of the tables replication uses:http://msdn.microsoft.com/en-us/library/ms179855(SQL.90).aspxand an explanation of each table and its use:http://books.google.co.uk/books?id=aup_ppJfgMcC&pg=PA236&lpg=PA236&dq=replication+system+table,+sql+server+2005&source=bl&ots=3czC-zScA1&sig=19eJbPUv6EtMg_dUZwecFZ3x5Tg&hl=en&ei=f6ZVSv-IB87RjAfCko3PAg&sa=X&oi=book_result&ct=result&resnum=3 |
|
|
|
|
|