Eric Barro
ebarro at afsweb.com
Thu Jul 21 13:10:16 CDT 2005
Yes you can do that by specifying the provider. It's not limited to SQL
server dbs for linked servers.
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Hartland
Sent: Thursday, July 21, 2005 8:50 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Linked Table In SQL Server
Oh sorry didn't explain myself fully the table I need to link in is in
Access format
PAUL HARTLAND
Database Designer/Programmer
paul.hartland at isharp.co.uk
ISHARP
DDI - 01922 472031
Mobile - 07730 523179
ISHARP (Information Services for Hospitality, Audit, Retail and
Pharmacy) provide IT resources for the Christie Group Stock & Inventory
Services companies.
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: 21 July 2005 16:43
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Linked Table In SQL Server
Using Enterprise Manager you can link to a "server" which can be another SQL
server.
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
Hartland
Sent: Thursday, July 21, 2005 5:47 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Linked Table In SQL Server
To all,
Is it possible to link (Not import) a table into an SQL Server Database, if
so would someone mind telling me how ?
Thanks in advance for any help.
PAUL HARTLAND
Database Designer/Programmer
Work Email:paul.hartland at orridge.co.uk
Private Email:paul.hartland at fsmail.net
ISHARP
DDI - 01922 472031
Mobile - 07730 523179
_______________________________________________
* This message is confidential.
* This email, its content and any files transmitted with it are intended
solely for the addressee and may be legally privileged and/or confidential.
* Access by any other party is unauthorised without the express written
permission of the sender.
* If you have received this email in error you may not copy or use the
contents, attachments or information in any way and any review, use,
dissemination, forwarding, disclosure, alteration, printing of this
information is strictly prohibited. Please destroy it and notify the sender
via return e-mail.
* This email has been prepared using information believed by Paul Hartland
to be reliable and accurate, but the company makes no warranty as to
accuracy or completeness. In particular the author does not accept
responsibility for changes made to this email after it was sent.
* Any opinions expressed in this document are those of the author and do
not necessarily reflect the opinions of the company or its affiliates.
The Orridge web site can be found at:
http://www.orridge.co.uk
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
----------------------------------------------------------------
The information contained in this e-mail message and any file, document,
previous e-mail message and/or attachment transmitted herewith is
confidential and may be legally privileged. It is intended solely for the
private use of the addressee and must not be disclosed to or used by anyone
other than the addressee. If you receive this transmission by error, please
immediately notify the sender by reply e-mail and destroy the original
transmission and its attachments without reading or saving it in any manner.
If you are not the intended recipient, or a person responsible for
delivering it to the intended recipient, you are hereby notified that any
disclosure, copying, distribution or use of any of the information contained
in or attached to this transmission is STRICTLY PROHIBITED. E-mail
transmission cannot be guaranteed to be secure or error free as information
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete,
or contain viruses.
The sender therefore does not accept liability for any errors or omissions
in the contents of this message, which arise as a result of email
transmission. Users and employees of the e-mail system are expressly
required not to make defamatory statements and not to infringe or authorize
any infringement of copyright or any other legal right by email
communications. Any such communication is contrary to company policy. The
company will not accept any liability in respect of such communication.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com
----------------------------------------------------------------
The information contained in this e-mail message and any file, document, previous e-mail message and/or attachment transmitted
herewith is confidential and may be legally privileged. It is intended solely for the private use of the addressee and must not be
disclosed to or used by anyone other than the addressee. If you receive this transmission by error, please immediately notify the
sender by reply e-mail and destroy the original transmission and its attachments without reading or saving it in any manner. If you
are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any
disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY
PROHIBITED. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or contain viruses.
The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of
email transmission. Users and employees of the e-mail system are expressly required not to make defamatory statements and not
to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is
contrary to company policy. The company will not accept any liability in respect of such communication.