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
