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

Linked server between sql server and oracle

Hi,
I have set up a linked server between sql 2000 and oracle9i database using MSDAORA. Linked server works fine for selecting data from oracle database .
I want to save a query in Sql server that includes a table from oracle9i and a table from local sql server,
I am getting this error :

Server: Msg 7391, Level 16, State 1, Procedure tr_banister, Line 16
The operation could not be performed because the OLE DB provider
'MSDAORA'
was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'MSDAORA'
ITransactionJoin::JoinTransaction returned 0x8004d01b].
Please help me .Reboot SQL server.
It is a known issue where Oracle driver has memory leaks. There are some service packs available to fix this.