Posted by ROAN on 10/08/05 00:46

Ootyguy napisal(a):
> Trying to do this all day and googling for answers but found none, hope
> someone can help. Thanks in advance.
>
> select * into
> OPENROWSET('SQLOLEDB','SERVER';'uid';'pwd',##test)
> from LocalTable
>
> Reason: I am joining local tables with linked server tables using the
> format "LinkedServer.database.owner.object" to execute a query, it
> takes forever to execute since the tables joined on the remote servers
> have more than 50Mil records. I read somewhere that sql server needs to
> copy the tables locally to the temp db and does the join there, hence I
> was hoping to dump the data of the local database into a temp table on
> the remote server and then do a join with OPENQUERY, which will execute
> the query on the linked server and return the results.


Using OPENROWSET for big tabels is not good idea, so you have right
trying copy this table.
To copy this tabel you can use for example DTS. It will take you couple
minutes and you'll have what you want.

[Back to original message]