Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

sp_get_distributor (Transact-SQL)

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 iconTransact-SQL Syntax Conventions

sp_get_distributor

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

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.