sp_get_distributor (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Topic link icon Transact-SQL Syntax Conventions

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 Management Studio in snapshot, transactional, and merge replication.

Permissions

Any user can execute sp_get_distributor. A non-NULL result set is returned when this stored procedure is executed by members of the db_owner or replmonitor fixed database roles on the distribution database, or members of the db_owner fixed database role on at least one published database. A non-NULL result set is also returned when this stored procedure is executed by users in the publication access list (PAL) of at least one published database, or in the PAL of the distribution database for a non-SQL Server Publisher, can also execute sp_get_distributor.

See Also

Configure Publishing and Distribution
Distributor and Publisher Information Script
Replication Stored Procedures (Transact-SQL)