--First set the data access option for the server using your SQL Server name (@@SERVERNAME).
exec sp_serveroption 'VALHALLA-MDD06H', 'data access', true
--Example:
use pubs
go
create table #tbl1( i int identity)
insert #tbl1 default values
insert #tbl1 default values
go
create proc sp1
as
SELECT 1 AS id
go
select *
from #tbl1 t1 join openquery([VALHALLA-MDD06H], '{call pubs..sp1}') t2
on t1.i = t2.id