Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Determines whether a Distributor is installed on a server. This stored procedure is executed at the computer where the Distributor is being looked for, on any database.



Result Sets
Column name Data type Description
installed int 0 = No
1 = Yes
distribution server sysname Name of the Distributor server
distribution db installed int 0 = No
1 = Yes
is distribution publisher int 0 = No
1 = Yes
has remote distribution publisher int 0 = No
1 = Yes


sp_get_distributor is used primarily by the Microsoft SQL Server Enterprise Manager in snapshot, transactional, and merge replication.


Members of the public role can execute sp_get_distributor.

See Also

System Stored Procedures

© 2015 Microsoft