Create SQL Statements that use Multiple Servers

[JulesDBQ]

I would like to create stored procedures that produce results based on data contained on two completely separate SQL Servers. I am administrator of the first server, so I have full rights to it...but, I am only a reader of the data on the second server - so I have no control of it.

I need to reference both of these servers to get the results I am looking for. I have poked around to see how this happens, but am unclear. I saw some information about linked servers...but I don't know if I will be able to do this, since I don't have rights to the second server.

Any assistance would be much appreciated. Thanks in advance!

 

[SQLDenis]

If you don't want to set up linked server you can use OPENROWSET, look it up in BOL
example

SELECT a.*
FROM OPENROWSET('SQLOLEDB','seattle1';'sa';'MyPass',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
GO


then you can join that result to your table

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[mrdenny]

As long as you have admin rights to the first server then you can setup a linked server to the second server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com