Groups | Blog | Home
all groups > sql server new users > april 2005 >

sql server new users : Linked Servers


Evan Camilleri
4/18/2005 12:00:00 AM
I am trying to link to another SQL Server from Linked servers.

The problem is that I am seeing a lot of tables starting

dtPropertiesm
MSreplication_options
...
sysxlogins

But none of "my" tables. I am sure that users have full rights in both
servers and I even tried using sa with pwd and set the security to be made
using security context and remotelogin=sa with correct pwd!

How can I see the tables?


Evan Camilleri

Evan Camilleri
4/18/2005 12:00:00 AM
ok solved. i need to specify catalog since i was referring to master table!!
though in the connection string was enough



[quoted text, click to view]

AddThis Social Bookmark Button