Connect MSSQL remotely by Query Analyzer

[ankitmathur]

Hi,

I wish to know the syntax for connecting to a remote MSSQL 2000 DB Server via Query Analyzer.

Actually my requirement is to use the connection string to connect to the remote server, execute a SQL Statement on the remote server & save the resultset in a table on my local machine.

Can anybody helpme ?

[ankitmathur]

Hi,

I have been able to do the task using the following code.


insert into some_table
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ServerName;User ID=MyUID;Password=MyPass'
).Northwind.dbo.Categories