create relationship with tables in a linked server

I need to create a relationship between a local table and tables on a
linked server. I used the design table wizard and selected the
relationship property wizard. In the reslationship property wizard,
the tables that I need to get the keys from in the linked server do not
show up. Is there a way to do this, or I simply don't have enough
permission to tables in the linked server. On the local server, the
Security tab of linked server property has Local Loging "sa", Remote
User "sa" and Remote Password "****". Thanks for your help.Hi

You can not create a relationship in this way, you are restricted to
definining FKs to tables in the same database. If you wish to force a
constraint between the local table and the remote one, you can write a
function that can be used in a check constraint or enforce it through
writing a trigger (which may be the faster and easier solution to
implement).

John

"js" <androidsun@.yahoo.com> wrote in message
news:1102725393.883680.211450@.z14g2000cwz.googlegr oups.com...
>I need to create a relationship between a local table and tables on a
> linked server. I used the design table wizard and selected the
> relationship property wizard. In the reslationship property wizard,
> the tables that I need to get the keys from in the linked server do not
> show up. Is there a way to do this, or I simply don't have enough
> permission to tables in the linked server. On the local server, the
> Security tab of linked server property has Local Loging "sa", Remote
> User "sa" and Remote Password "****". Thanks for your help.

Create linked server in SQL 2005 from Excel spreadsheet and have primary key?

Is it possible to create a linked server from an Excel spreadsheet and give it a primary key? If so, how?

Thanks,

--Stan

This was for a Report Builder issue that I've resolved another way, but it's still an interesting question for other uses...

|||

No, Excel has no idea of Primary Keys, using Report Builder you probably would create a logical primary key to accomplish the creation of relationships.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Create Linked Report method

Does anyone have a sample of a CreateLinkedReport method they are using? I am using Reporting Services 2005 and Visual Basic 2005. I need the VB code and how I need to call it. I'd like to change one parameter, and then send it to select recipients using a specified schedule.

Thanks, Iris

Is there anything wrong with the BOL sample code?|||

I'll try that example.

Also, when I try to click Create Linked Report from a master report that I created, I get an internal error. In SS SP2, it shows that this problem was fixed. When I installed SP2 today, it did not fix the problem. I am using a Stored Procedure with one parameter of int value.

Any ideas?

Thanks, Iris

Create linked exchange server

I'm using sql server 2005 and exchange 2003. End result is I want to upload email attachments to a table in sql. No one seems to have any idea how do do this except with .net, which i know nothing about so not really an option for me. I found this bit of info with some extensive web searching. Can anyone help fill in the blanks? I can't get the linked server to work yet.

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\mailservername\public folders'

Error received:The OLE DB provider "exoledb.DataSource.1" has not been registered.

Does the Exchange Ole DB Driver exist on the SQL Server machine? I am assuming the 2 services are not on the same machine. If not, you may need to install the Exchange SDK or management tools on the SQL Server to get the OleDB driver installed.

Create linked exchange server

I'm using sql server 2005 and exchange 2003. End result is I want to upload email attachments to a table in sql. No one seems to have any idea how do do this except with .net, which i know nothing about so not really an option for me. I found this bit of info with some extensive web searching. Can anyone help fill in the blanks? I can't get the linked server to work yet.

EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\mailservername\public folders'

Error received:The OLE DB provider "exoledb.DataSource.1" has not been registered.

Does the Exchange Ole DB Driver exist on the SQL Server machine? I am assuming the 2 services are not on the same machine. If not, you may need to install the Exchange SDK or management tools on the SQL Server to get the OleDB driver installed.

Create link to dBase?

Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.Using linked server is one of the ways, and I will probably go with that.
But am not sure where to get your BDE drivers...try Googling :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com> wrote
in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.|||I have googled for it but haven't found a way to get a copy yet.
I am open to any methods really. I really would prefer not to use BDE.
Thanks,
Marc.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OzhenZt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
> Using linked server is one of the ways, and I will probably go with that.
> But am not sure where to get your BDE drivers...try Googling :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com>
wrote
> in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I was wondering what is the best way to link MS SQL server 2000 to dBase
IV.
> From what I can gather, we should create a linked server and use the MS
Jet
> 4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
> dBase files.
> Is this the correct way? If so, does anyone know where to get a working
> version of BDE?
> Thanks,
> Marc.
>
>