exec sp_serveroption 'IRVN78', 'data access', true

use CCL36

create table #test1( i int )

insert #test1 values (1)

insert #test1 values (2)

create proc sp_test

SELECT 2 AS id

select *

from #test1 t1 join openquery([IRVN78], '{call CCL36..sp_test}') t2

on t1.i = t2.id

To be continue........

hey suman can we start a single thred on SQL instead of Part n Part. and if you use adventureWorks database then it will help to run a query

thanks