Posted by Erland Sommarskog on 12/08/05 23:52

mike (-nospam@yahoo.com) writes:
> I added a linked server successfully; but the only tables accessible are
> only the system tables!
> I do have all the rights on both servers (Windows & SQL server).
>
> All the non system tables are designated as DBO.
>
> Strange thing is that I was able to access the non system tables only
> from the query analyzer (not from the SQL Manager tree) by using the
> following script:

That may be true that you can't see the tables in a linked server from
a graphical management tool. After all that could be a costly operation.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: datetime
• Prev in forum: Re: Database security (crosspost)
• Thread view: Re: When Linking A Server; Only System Tables Are Accessible!

[Reply to this message]