--********** Execute at the Distributor in the master database **********-- USE master; go --Is the current server a Distributor? --Is the distribution database installed? --Are there other Publishers using this Distributor? EXEC sp_get_distributor --Is the current server a Distributor? SELECT is_distributor FROM sys.servers WHERE name='repl_distributor' AND data_source=@@servername; --Which databases on the Distributor are distribution databases? SELECT name FROM sys.databases WHERE is_distributor = 1 --What are the Distributor and distribution database properties? EXEC sp_helpdistributor; EXEC sp_helpdistributiondb; EXEC sp_helpdistpublisher;
How to find Distributor , Distributor server and Distributor databases in SQL Server Replication
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment