Wednesday, April 11, 2007

replication : sp_get_distributor

Determining Replication setup using sp_get_distributor -

results on publisher
installeddistribution serverdistribution db installedis distribution publisherhas remote distribution publisher
1SQL_DIST01000

results on distributor
installeddistribution serverdistribution db installedis distribution publisherhas remote distribution publisher
1SQL_DIST01111

results on subscriber
installeddistribution serverdistribution db installedis distribution publisherhas remote distribution publisher
0NULL000

No comments: