=====================================================
Create proc dbo.up_tablelists
as

Create table #t
(TABLE_CAT varchar(250),
TABLE_SCHEM varchar(250),
TABLE_NAME varchar(250),
TABLE_TYPE varchar(250),
REMARKS varchar(250))

insert into #t exec sp_tables_ex 'linkserver'
select TABLE_NAME from #t where TABLE_TYPE='TABLE'