Home Forums SQL Server 2005 Administering Urgent Questions about Replication and Partition table RE: Urgent Questions about Replication and Partition table

  • If you would like to resolve your issue with Replication here is the solution:

    Use Transactional replication to replicate data from

    A.T1 to C.TA

    B.T1 to C.TB

    Create View T1 combining C.TA & C.TB.

    For Partition refer following site:

    http://msdn2.microsoft.com/en-us/library/ms345146.aspx#sql2k5parti_topic23

    Hope this will help. Good Luck!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."