Udostępnij za pośrednictwem


sp_validate_redirected_publisher (Transact-SQL)

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.

Ikona łącza do tematu Transact-SQL Syntax Conventions

Składnia

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.

Uwagi

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.

Zobacz także

Odwołanie

Replication Stored Procedures (Transact-SQL)

sp_get_redirected_publisher (Transact-SQL)

sp_redirect_publisher (Transact-SQL)

sp_validate_replica_hosts_as_publishers (Transact-SQL)