In Transactional Replication, is it possible to replicate databases
with the same name located on multiple servers (i.e. Pubs on Server1,
Server2 and Server3) onto one central server (i.e. Pubs1 on Server4,
Pubs2 on Server4, Pubs3 on Server4 etc.).
I know I can pull this off using stored procedures but i'm looking for
an easier way.
Details arn't needed....if it is possible and someone can point me in
the right direction, it would be deeply appreciated.
Thanks!
Clayton
