Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_get_distributor

SQL Server 2000

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.