Can only see system tables

Hello,

I have created a linked server XYZ that is linked to server ABC. I am tying to view the tables via XYZ but I'm unable to do so. I can only see the system tables. When I run a select statement, I get the correct results. That means I have the access to the tables, yet why am I not able to see the tables.

Please assist

That highly depends on the type of linked server you are accessing. Which server are you accessing ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de