Hi,
I need to insert and update data from one server to another. I have been searching in the internet and I have found some articles about OPENQUERY, OPENDATASOURCE and OPENROWSET.
To use OPENDATASOURCE and OPENROWSET I have to set the Ad Hoc Remote Queries Ħ°onĦħ, in my pc this is fine because I have sql server 2005 and I just need to go to surface area configuration and set it to Ħ°onĦħ. But for the company I works for the development server have SQL Server 2000. How do I turn this on in sql server 2000
If there is a better way of doing this please tell me.