Transact-SQL Reference

sp_get_distributor

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.

Syntax

sp_get_distributor

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

Remarks

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

Permissions

Members of the public role can execute sp_get_distributor.

See Also

System Stored Procedures