View list of tables on linked server

[DataMiner]

At long last I've gotten my IT department to set up a link to a remote server. Sure would be nice to be able to view the list of tables on the remote server! The only way I've found to do this so far is by using a system stored procedure:

sp_tables_ex
@table_server = 'DTMFLKSVDB03',
@table_catalog='FnetIntranet',
@table_schema='dbo'

How can I set up a VIEW to return this same information?

 

[SQL_Hell]

Use this code:

select * from <servername>.<databasename>.sys.sysobjects where type ='u'

 

[DataMiner]

Thanks, just what I needed!