Create sp in serverA to select data from remote_server and call the sp from server B, C and D.

create procedure sp2000_helpdb

as

select * from [remote_server].master.dbo.sysdatabase

in server A

exec [server_A].master..sp2000_helpdb

in server B, C, and D

Edited by - Allen_Cui on 05/28/2003 1:20:05 PM