amendez


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.




Re: Insert data from one server to another

hunchback


In that case you will get better results using a linked server.

Configuring Linked Servers

http://msdn2.microsoft.com/en-us/library/aa213778(SQL.80).aspx

AMB






Re: Insert data from one server to another

richbrownesq

Note that the Surface Area Configuraiton tool is new to SQL2005 and many things that could be considered a security risk (eg Ad Hoc Remote Queries) are off by default. SQL2000 does not have this level of protetction and so you should be able to use OPENROWSET etc "out of the box".

HTH!