Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
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.
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.