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.
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 Enterprise Manager in snapshot, transactional, and merge replication.
Members of the public role can execute sp_get_distributor.