sp_get_distributor (Transact-SQL)
Applies to:
SQL Server
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.
Transact-SQL syntax conventions
Syntax
sp_get_distributor
[ ; ]
Arguments
None.
Result set
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 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
.
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें