How to access dbs on different serves

[jararaca]

Hi,

How do I refer to a database on a different SQL Server from inside a view or stored procedure? Both servers are registered in MMC (or Enterprise Manager).

Thank you!

 

[SQLDenis]

you have to set up linked servers
Lookup linked servers in BOL
after you set it up it's just ServerName.DatabaseName.ObjectOwner.TableName


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jararaca]

Thanks for the reply. Please pardon the ignorance, but how do I access bol?

Thank you!

 

[SQLDenis]

Books On Line

C:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jararaca]

Thanks. It doesn't want to open it when I double-click on it, and judging by the icon, the file does not seem to have an association. When I open it in a text editor or Explorer, tt seems to be an XML file. How do you open it to view it properly?

Thanks, again.

 

[SQLDenis]

start-->programs-->microsoft sql server-->books on line

or hit F1 from query analyzer

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jararaca]

thank you!