469,362 Members | 2,548 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,362 developers. It's quick & easy.

Working Linked Servers

Hi,

I was thinking abt linked servers deals only with multiple servers
physically inter-connected.

Now i come accross that we can link our non-sqlserver databases also.
It is thru the E.manager by
Security->linked servers -> Other databases -> access(jet 7.0).mdb

if it is ok , all the tables under that given db will be listed , but
is not opening via E.M.
Accessing the linked servers.
----------------------------------
select * from raghu...tablename.

raghu is the linked server name.

It works nice. Even u can give the rights also.Hope this useful to the
beginners.
With thanks.
Jul 20 '05 #1
3 3576
Raghuraman wrote:
Hi,

I was thinking abt linked servers deals only with multiple servers
physically inter-connected.

Now i come accross that we can link our non-sqlserver databases also.
It is thru the E.manager by
Security->linked servers -> Other databases -> access(jet 7.0).mdb


Where do you find "Security" ? right-clicking on something, or in a menu
somewhere ?

/jim
Jul 20 '05 #2
On Fri, 28 Nov 2003 12:05:57 +0100, "Jim Andersen"
<jimVÆÆK@officeconsult.dk> wrote:
Raghuraman wrote:
Hi,

I was thinking abt linked servers deals only with multiple servers
physically inter-connected.

Now i come accross that we can link our non-sqlserver databases also.
It is thru the E.manager by
Security->linked servers -> Other databases -> access(jet 7.0).mdb


Where do you find "Security" ? right-clicking on something, or in a menu
somewhere ?

/jim

It's in the default left pane of enterprise manager, once you have a
server selected, under replication. Perhaps you don't see it if you
aren't an admin?
Jul 20 '05 #3
Lyndon Hills <ly****@nospam.tenegi.com> wrote in message news:<pf********************************@4ax.com>. ..
On Fri, 28 Nov 2003 12:05:57 +0100, "Jim Andersen"
<jimVÆÆK@officeconsult.dk> wrote:
Raghuraman wrote:
Hi,

I was thinking abt linked servers deals only with multiple servers
physically inter-connected.

Now i come accross that we can link our non-sqlserver databases also.
It is thru the E.manager by
Security->linked servers -> Other databases -> access(jet 7.0).mdb


Where do you find "Security" ? right-clicking on something, or in a menu
somewhere ?

/jim

It's in the default left pane of enterprise manager, once you have a
server selected, under replication. Perhaps you don't see it if you
aren't an admin?



------
Hi,

Hills
For working with linked servers , You replied like , one can not see
the login rights etc if the particular user is not in the admin role
in the Enter prise manager regarding the replication.

Since the E.Manager is a open book so that any one can access any
database , Do you explain me When the sql server E.manager aks the
user's login and password .
With thanks

RAGHU
Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Ervs Sevilla via SQLMonster.com | last post: by
8 posts views Thread by Ootyguy | last post: by
3 posts views Thread by RandyMartin | last post: by
1 post views Thread by tim.pascoe | last post: by
reply views Thread by Abyss7 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.