Join to a table in another database on a different server

[coolmoe]

am looking at reference a sql server database from a separate sql server database.
server 'a' has table 'tbl_cars'
server 'b' has table 'tbl_colors'

i wish in a stored procedure for example to link from server 'a' to tbl_colors in server 'b'. also, there is a login and password to get to the other server.

 

[robsuttonjr]

have you tried using a linked server or dts to get the data?

The more I learn the more I find I know nothing.

Rob

 

[coolmoe]

Not sure how to do either one

 

[JamesLean]

Look up "linked servers" in Books Online. Once you have one set up you can query it bu using fully-qualified object names:

SELECT * FROM server.database.owner.table

--James