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.