Transactional replication?

Perhaps you should explain the problem you are trying to solve.

Perhaps you should explain the problem you are trying to solve. You only need one publisher per database. One distribution agent can distribute to many subscribers.

The distribution agent is usually on a different server to the publisher; subcribers can be located on the same server as the distributor. The maximum number of subcribers is mainly limited by network bandwidth and the capability of the drives where the Transaction log file of the publisher resides.

My databases have been deployed seperately... there are different database servers so there will be different publishers and perhaps acc to my settings different distributors too...i needed data of few tables centrally for some other purpose. I solved this problem. Thx fr d other information you gave.

– Samiksha Dec 1 '08 at 13:16.

I have not heard of a "logical" limit to publications/subscriptions. Your limitation will either be linked to licensing (some SQL versions have limited rights for publications) or hardware issues, as noted by @Mitch.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.