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;
|
|
|
|
|
|