Access data on another server from a stored procedure

[malcolm45]

Can I use a stored procedure on server A to reference data in a database on server B in Server 2000.

I need to be able to combine the data with data from other databases on server A to produce a combined result.

 

[SQLDenis]

yes, you need to setup a linked server
lookup linked server in BOL

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLSister]

don't forget to use the four part name as well when you refer to the linked table.

"NOTHING is more important in a database than integrity." ESquared