Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



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;