sys.sp_get_distributor

Description

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

distribution db installed

Permissions

Any user can execute. A non-NULL result set is returned when this stored procedure is executed by members of the or fixed database roles on the distribution database, or members of the 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. Configure Publishing and Distribution Distributor and Publisher Information Script Replication stored procedures (Transact-SQL)

Remarks

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.

Description

Name of the Distributor server

is used primarily by the SQL Server Management Studio in snapshot,

transactional, and merge replication.

Expand table