sp_get_redirected_publisher (Transact-SQL)
Applies to: SQL Server
Used by replication agents to query a distributor to determine whether the original publisher was redirected.
Transact-SQL syntax conventions
Syntax
sp_get_redirected_publisher
[ @original_publisher = ] N'original_publisher'
, [ @publisher_db = ] N'publisher_db'
[ , [ @bypass_publisher_validation = ] bypass_publisher_validation ]
[ , [ @multi_subnet_failover = ] multi_subnet_failover ]
[ ; ]
Arguments
[ @original_publisher = ] N'original_publisher'
The name of the instance of SQL Server that originally published the database. @original_publisher is sysname, with no default.
[ @publisher_db = ] N'publisher_db'
The name of the database being published. @publisher_db is sysname, with no default.
[ @bypass_publisher_validation = ] bypass_publisher_validation
Used to bypass validation of the redirected publisher. If 0
, validation is performed. If 1
, validation isn't performed. @bypass_publisher_validation is bit, with a default of 0
.
[ @multi_subnet_failover = ] multi_subnet_failover
Applies to: SQL Server 2022 (16.x) CU 10 and later versions
Used to pass information for the creation of the dynamic linked server. If 0
, the dynamic linked server isn't created with the MultiSubnetFailover
parameter. If 1
, the dynamic linked server is created with the MultiSubnetFailover
parameter as 1
. @multi_subnet_failover is bit, with a default of 0
.
Return code values
0
(success) or 1
(failure).
Result set
Column name | Data type | Description |
---|---|---|
redirected_publisher |
sysname | The name of the publisher after redirection. |
error_number |
int | The error number of the validation error. |
error_severity |
int | The severity of the validation error. |
error_message |
nvarchar(4000) | The text of the validation error message. |
Remarks
redirected_publisher
returns the current publisher name. Returns NULL
if the publisher and publishing databases aren't redirected using sp_redirect_publisher
.
If validation isn't requested or if no entry exists for the publisher and the publishing database, error_number
and error_severity
return 0
and error_message
returns NULL
.
If validation is requested, the validation stored procedure sp_validate_redirected_publisher (Transact-SQL) is called to verify that the target of the redirection is a suitable host for the publishing database. If the validation succeeds, sp_get_redirected_publisher
returns the redirected publisher name, 0
for the error_number
and error_severity
columns, and NULL
in the error_message
column.
If validation is requested and fails, the redirected publisher name is returned along with error information.
Permissions
Caller must either be a member of the sysadmin fixed server role, the db_owner fixed database role for the distribution database, or a member of a publication access list for a defined publication associated with the publisher database.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru