October 3, 2007 at 2:29 pm
Hi , I have two publication of two different database and they are replicating data to other server but both are sending data to same database with transactional replication , now my question is ,can i have two different distribution jobs for these two publications , currently we have one job only since subscriber database is same for both the publication databases ?
October 3, 2007 at 2:34 pm
below are the detail for our setup
below is the detail for our setup
publisher -SQL 2000
distributor-SQL 2005
subscriber-SQL 2000
October 3, 2007 at 3:22 pm
sqlquery (10/3/2007)
Hi , I have two publication of two different database and they are replicating data to other server but both are sending data to same database with transactional replication , now my question is ,can i have two different distribution jobs for these two publications , currently we have one job only since subscriber database is same for both the publication databases ?
Y E S
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply