I want to know how to transfer between two server a data table without using the SPROC for link them.
Microsoft SQL Server includes a popular command-prompt utility named bcp for moving data from one table to another, whether on a single server or between servers. The SqlBulkCopy class lets you write managed code solutions that provide similar functionality. There are other ways to load data into a SQL Server table (INSERT statements, for example), but SqlBulkCopy offers a significant performance advantage over them. http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx