Linked Server Object Listing

In SQL 2000's Enterprise Manager, upon selecting a linked server the accessible tables and views would be displayed in the right pane. This does not seem to be the case with SQL 2005's Management Studio. I'm seeing this behavior (or lack thereof) with links to a variety of platforms: Sybase ASA, Oracle, and MSS 2000.

To rule out a permission problem, I've confirmed the ablity to query sysobjects, ALL_TABLES, etc. Is this a driver or configuration problem, or is this functionality simply absent?

Try manually issuing

select * from sys.servers

while running under the same security context you use while in SSMS. You should be able to see rows for any linked server you have a remote or linked login to (sys.remote_logins or sys.linked_logins).

If you have the ALTER ANY LINKED SERVER or ALTER ANY LOGIN permision, or are a member of the setupadmin or sysadmin groups, then you should see all rows.

If you are not seeing rows, then this is "by design" behavior. See http://msdn2.microsoft.com/en-us/library/ms187113.aspx for more info.

If you are seeing rows, then repost or consider filing a bug.

Thanks