I want to know how to transfer between two server a data table without using the SPROC for link them.

SqlBulkCopy

That will not work. I am using an Update statement with the two servers at the same time. Thanks any how, I made it in a different way.

It does work, just because you don't use it doesn't mean it's broken.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.