How to transfer data from sql server without linked server
Posted on 2011-02-18
I have setup a SQL 08 express database locally. I want to load a table in my express database based on data in a database on a server. I have read access to the server (via windows authentication), but setting up linked server on that server is not an option. What is the best method to use (opendatasource, openquery, openrowset, etc) in order to query the server and then insert the results into my sql express database. Please provide syntax for using the commands if possible.