info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



T-SQL - Check Always On Transactional Replication re-directed Publisher to Listener Name
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2018-08-22








T-SQL:


Declare @Redirected_publisher sysname;
Exec dbo.sp_validate_redirected_publisher @original_publisher='VMSQL01', @publisher_db='DB01', @redirected_publisher=@redirected_publisher output
Select @redirected_publisher

Exec sp_Validate_Replica_Hosts_As_Publishers
@Original_publisher = 'VMSQLA01',
@Publisher_DB = 'DB01',
@Redirected_Publisher = @Redirected_Publisher output;
Select @Redirected_Publisher

Select * from dbo.MSRedirected_Publishers;