EXEC sp_addserver 'local',null,'your_server_name'

create procedure testproc
 @namelike varchar( 50 )
as select id, name from sysobjects where name like @namelike
go
create existing table proxy_testproc (
  id int,
  name varchar( 30 ),
  _namelike varchar( 50 ) null,
) external procedure at 'local.your_database_name.dbo.testproc'
go
select * from proxy_testproc where _namelike='sysc%'
go
select * into #tmp from proxy_testproc where _namelike='sysc%'
go
select * from #tmp
go