• For loading millions of records, it's better to use SSIS. You'll have good performance benefits.

    Linked servers are good for less amount of data.

    --

    SQLBuddy