Skip to content

Latest commit

 

History

History
83 lines (56 loc) · 3.51 KB

sp-validate-redirected-publisher-transact-sql.md

File metadata and controls

83 lines (56 loc) · 3.51 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_validate_redirected_publisher (Transact-SQL)
Verifies that the current host for the publishing database is capable of supporting replication.
markingmyname
maghan
randolphwest
11/14/2023
sql
replication
reference
sp_validate_redirected_publisher
sp_validate_redirected_publisher_TSQL
sp_validate_redirected_publisher
TSQL

sp_validate_redirected_publisher (Transact-SQL)

[!INCLUDE SQL Server]

Verifies that the current host for the publishing database is capable of supporting replication. Must be run from a distribution database. This procedure is called by sp_get_redirected_publisher.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_validate_redirected_publisher
    [ @original_publisher = ] N'original_publisher'
    , [ @publisher_db = ] N'publisher_db'
    , [ @redirected_publisher = ] N'redirected_publisher' OUTPUT
    , [ @multi_subnet_failover = ] multi_subnet_failover
[ ; ]

Arguments

[ @original_publisher = ] N'original_publisher'

The name of the instance of [!INCLUDE ssNoVersion] 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.

[ @redirected_publisher = ] N'redirected_publisher' OUTPUT

The target of redirection specified when sp_redirect_publisher was called for the publisher/database pair. @redirected_publisher is an OUTPUT parameter of type sysname.

[ @multi_subnet_failover = ] multi_subnet_failover

Applies to: [!INCLUDE sssql22-md] 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

None.

Remarks

If no entry exists for the publisher and the publishing database, sp_validate_redirected_publisher returns null in the output parameter @redirected_publisher. If an entry exists, it's returned in the output parameter in both success and failure cases.

If the validation succeeds, sp_validate_redirected_publisher returns a success indication.

If the validation fails, errors are raised describing the failure.

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