i am looking at reference a sql ser

[coolmoe]

i 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.

 

[JamesLean]

Please don't cross-post. See thread183-692691

--James