I have a sql server. The publisher is setup to use distributor 'A'. There are several publications that use this distributor. I have created a publication. I want this publication to use a different distributor ('B'). When I try to set up a new Push Subscription, I am defaulted to distibutor 'A' and I need to use distributor 'B'. Can anyone tell me how I can configure this publication to use a different distributor to I can set up the Push Subscription? Thank You, Robert
Review books online about setting up distributor and following articles : http://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm http://www.databasejournal.com/features/mssql/article.php/1438231 http://www.databasejournal.com/features/mssql/article.php/1458491 Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.