sp_validate_redirected_publisher (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Topic link icon Transact-SQL Syntax Conventions

Syntax


      sp_validate_redirected_publisher   
    [ @original_publisher = ] 'original_publisher',  
    [ @publisher_db = ] 'database_name',   
    [ @redirected_publisher = ] 'new_publisher' output  

Arguments

[ @original_publisher = ] 'original_publisher'
The name of the instance of SQL Server that originally published the database. original_publisher is sysname, with no default.

[ @publisher_db = ] 'publisher_db'
The name of the database being published. publisher_db is sysname, with no default.

[ @redirected_publisher = ] 'redirected_publisher'
The target of redirection specified when sp_redirect_publisher was called for the publisher/database pair. redirected_publisher is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

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 is 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.

See Also

Replication Stored Procedures (Transact-SQL)
sp_get_redirected_publisher (Transact-SQL)
sp_redirect_publisher (Transact-SQL)
sp_validate_replica_hosts_as_publishers (Transact-SQL)