Posted by mike on 12/08/05 22:49

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:


EXEC sp_addlinkedserver 'LINKED_SERVER_NAME', N'SQL Server'
GO
Set ANSI_NULLS on
Set ANSI_WARNINGS on
GO
Select * From LINKED_SERVER_NAME.Database_name.DBO.table_name
GO

Thank you very much

Mike

*** Sent via Developersdex http://www.developersdex.com ***

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

[Reply to this message]